I’ve had dogs for over 30 years and I would say you get out what you put in. Also realistic expectations, there will be dog poo to clean up (including accidents in the house at first) and hair on every item of clothing and often in your dinner as well. You will lose some of the spontaneity you may have had previously, as the dog’s needs will have to be considered every time you want to go out/away for the weekend/on holiday etc, but honestly that’s all easily sorted if you are sensible and practical.
Puppyhood is definitely the most difficult time, but it doesn’t last forever and if you put the effort in you will have a loving, loyal companion who will make it all worthwhile and then some.
As a first time dog owners, I would recommend booking yourself in with a positive 1:1 dog trainer as soon as possible. Some even do pre-puppy appointments to help you make sure you are all set up and ready to go. Start as you mean to go on, working with someone who knows what they are doing and can support you if you need advice and most of all, don’t be too uptight about it all. What young puppies need most is love, security and consistency, yes they need training and socialisation as well, but first and foremost they need to feel safe and that they can always trust you to have their backs, that’s what builds confidence, which ultimately is one of the most important traits of a contented, well adjusted dog. The good news is, this means (despite what some people might suggest) lots of cuddles, fun games and interactions that are rewarding for both of you. Yes, it can be exhausting having a puppy, in the same way as it can be having a toddler BUT having a puppy should be fun and rewarding as well.
I am sure you will be fine, as you said in your op, if dogs are really that awful to live with, why would people like me and countless others in The Doghouse carry on having them.
My family is hurting at the moment from the loss of our very old boy yesterday. First time we have not had a dog in over 33 years, but we are all agreed that, when we have had some time to grieve and feel ready, we will be opening our hearts and home to another dog without hesitation.