I have a miniature smooth haired dachshund and she is just wonderful.
She was yappy as a tiny puppy when wanting her food etc but i taught her quiet and now she only barks if someone comes to the door.
Toilet training took her 6 months to be fully toilet trained ( so 4 months of work for us, but accidents were much less in the last month or so)
I work from home which really helped with her training. She hates being left alone, if I need to go to the office once a month i put her in to doggy day care and she is happy there. I can leave her for an hour to go to the shops etc but thats about it. She doesn't destroy anything or have accidents, just cries and is upset.
She would sit on a knee all day if she could, sleeps and looks out the window most of the day, one good walk of around 45 mins is enough for her and she goes to the backdoor to get out for the loo the rest of the day. She does not like rain or traffic so i try to go out when its dry and go to a park etc as she enjoys it much better.
I pay around £35 a month for her insurance.
She walks nicely on the lead, doesn't bark when out walks, is fine with cats and loves other dogs, will be quiet and sits nicely when asked. But thats as much training as we mastered as she struggled with lie down, wait etc and i didnt train it further, but im happy with her behaviour she is a lovely wee dog.
Walks can take a while as everyone loves her and stops to pat her which she absolutely loves!
I wasnt prepared for just how small she was when I got her, she was so tiny and such a baby I underestimated the level of care required for the first couple of months but i loved it and love her.