I totally agree with the comment "find a breed that makes your heart sing".
I don't have any experience with a Cavapoo, but can offer my biased experience with our whippet, which has suited us perfectly, but you may not like the skinny aesthetic if you were thinking of a spaniel.
Pro
Affectionate, love a cuddle, but not overly demanding.
Rarely aggressive. as running away is their defence.
Personal taste, but I love the calm, none aggressive, and built-for-speed look.
Good gene diversity, so generally healthy
Good with children and other dogs
Can sleep / snooze 20 hours a day, often with their legs in the air!
Do not require huge amounts of exercise, i.e. 30-40 minutes a day, but will do a long walk when required.
Can outrun nearly every dog in the park.
Don't bark much, but communicate when they do. (food/playtime/cat)
Doesn't over eat. (or eat "nasty" things in the park)
Stay clean due to short hair, minimal shedding and zero grooming bills.
Usually good recall, unless it's after a squirrel.
Plenty of opportunity to accessorise, i.e. coats and jumpers
Can live with cats, especially if the cats are established.
Still playful at 4+ years
Low odour. (apart from very occasional devastating pharts)
Cons
Puppies have needles for teeth.
Will insist on sleeping in your bed, usually not negotiable.
Happier in a coat when it's remotely cold.
Hates rain
Likes a blanket to lie on, in pubs etc
Often fast enough to catch and kill squirrels. (ours isn't)
Limited obedience, will sit, come etc, but forget tricks.
Often not keen on being left alone, ours is okay if walked first.
Insist in sniffing your breath every morning, not an issue once you work it out.
Can be a little nervous if not socialised as a pub.
As with most puppies, socialisation and exposure early on is key.
As a family, try to borrow some friend's dogs for 24 hours, as it will give you more perspective on dog ownership.
Whilst we found having a dog was of huge benefit for the children, their interest usually wanes and you'll be doing most of the work.
Also worth looking at the "running costs", as insurance can vary significantly with different breeds.