I want a dachshund or other small dog because it seems like a good middle ground

Sorry for the unsolicited advice, but please do think it over. Dachshunds (and many other small breeds) actually require quite a lot of activity and exercise (mental and physical)*. If those needs aren't met, that can cause so many difficult behavioral problems. They're working dogs, after all: if they aren't given a job, they'll find one themselves (and it'll be likely something very annoying or unpleasant to you)

*yes, it does depend on the individual dog, but the general tendency points to those breeds being high energy

#tons of small breeds were made specifically to hunt small fast animals so like. don't get a small dog thinking it'll be easier#dachshunds were bred to hunt badgers. do you want a dog with the need to hunt badgers or do you want a little dude to hang out with#if it's the latter just get a cat