I contemplated getting a dog for years before I actually did. I didn't like the idea of not being able to just go out for the day without lots of planning etc, but then I realised those days are quite few and far between anyway! It really depends on your current lifestyle.
My pup was everything other posters have described, she bit, chewed and destroyed many things but this was only for a couple of months. I'd say by 6 months she was the perfect dog inside the house, and perhaps by 12 months or so, walks became much more enjoyable as she calmed down and stopped pulling my arm out it's socket every time she saw a passerby or dog. She didn't go through the teenage stage many describe, thankfully!
My boys were almost 7 and 9 when we got her. As I suspected, they don't help with any of the 'boring' things, but they do love her unconditionally and she's been a fantastic addition to our family. She definitely thinks she's one of them and she's everything another sibling would have been for them, without the bickering 😂
She's fine being left alone for a few hours - she just sleeps. Never had any issues at all with separation anxiety, despite her being like velcro when we're in the house. One of the reasons I went for a bigger dog was as my research said they might be less prone to anxiety, obviously this depends on breed, but it worked for us.
If you're keen on a poodle mix, I'd look more at poodles crossed with goldens or labs. Australian labradoodles especially, as there are far more generations of them and there's more of a "breed" standard. They seem to be a lot calmer than cockapoos. It's imperative you do your research though as there are so many puppy farms out there. Hip/elbow scoring for both parents and all other related genetic testing, including eyes. This will narrow your choice massively as most litters advertised won't have this, they'll just say puppies are fully health checked, which isn't the same.
My dog is GR/lab/standard poodle. She's mostly poodle but doesn't really have any poodle traits, so you really never know what you'll end up with, so you must be prepared to put up with the worst of any breeds involved! She also doesn't look like any of her breeds. Mine is lovely though, she has an amazing temperament and is so laid back and chilled and other dog walkers always comment on this. I appreciate I may have been lucky though!