that's interesting @Wolfiefan. I recently got a 6 month old Mini Schnauzer male whose owner (a relative by marriage) died unexpectedly. He is delightful, loves other dogs and people, is quite different to train than my Golden Retriever, that's for sure, more terrier-like, (Golden retriever "what do you want me to do?" MS "you want me to do what?") but he's not generally yappy, or rather it was not difficult to teach him a "quiet" command before letting him out of the car (which was his most noisy period). I see @scullie has had the same experience. Mine is a smart little thing, and now he's bonded with me is beginning to really "get it" with obedience.
Its not a breed I knew much about - so I joined a forum - and there are a few people who describe bad behaviour and add "oh but's that's mini schnauzers for you" - so I do think there is a perception among some owners that there's nothing they can do about yappy, unsocialised, dogs. Luckily my dog's original owner chose her breeder carefully, all health checks done (lovely informative puppy pack, and I've seen a few!) and did lots of early socialising and basic obedience, so we hit the ground running. I fully expect, if I put the work in, that he will be eventually doing advanced obedience and agility just like the Golden Retriever.
It's a breed I would now recommend, BUT it is popular so there are lots of puppy farm dogs and hobby breeders using their pet male and female dogs, you have to be really careful to get a nice dog with a steady temperament and good health. They are also very prone to pancreatitis, so diet has to be carefully managed.
I'd also go with a puppy if you have a cat, I have had older rescues with my cats, often successful, but one elderly cat seriously injured by a rescue and had to be PTS. That was not a successful rescue as the dog was out of control and we had other animals and toddlers and had been told a sob story about the dog that simply wasn't true. I've had rescues since that were great with the cats, but the current Mini S is a chaser and we are still working on that.
good luck @pinkpip100, wait until lockdown is over and prices come down, think carefully about breed. Gundog breeds are generally brilliant with kids, but they are "mouthy" - especially the retrievers - which means quite nippy as pups, and puppy teeth are very sharp, my mini schnauzer adores children and is very gentle with them (original owner had grandchildren he saw quite regularly I think).
my friends who've had hound breeds claim that they are so laid back that they are comatose most of the day... but you'll have to ask Wolfiefan about that! I also have to admit that the people I know who have cockerpoos do rave about them.