Any dog can develop hyperactive behaviors, behavioral problems, etc if not provided with a proper outlet for physical and mental energy. Figuring out how much and what kind takes flexibility on your part to add (or remove) exercise, training, etc etc as needed based on the dog's behavior in the home.
It's.... not really something we can determine exactly for a non-existent dog, you know? No one will be able to tell you if the dog you wind up with will absolutely only need x-minutes of walking or will be fine with only x-minutes of playing fetch. Some dogs need more than others, even of the same breed. The closest you could probably get to a guesstimate would be talking to breeders and asking them if their dogs tend to run hyper or if they're calmer stock. Ask rescues if they have an older, calmer dog in foster.
That said, IMO a smaller dog is going to be easier to handle physically - if they get hyper and start zooming around your home, they're less likely to knock stuff over (including you). They're not going to be able to drag you out the door, or jump up and knock you over. Smaller dogs are also more easily able to expend energy indoors or in smaller yards. So in that regard, a smaller dog may be a better bet for you.
I do NOT, however, think smaller dogs have "less energy" than larger dogs - it's just not as much of an issue to have a 16 pound dog running around like a lunatic in comparison to a 50+ pound dog. So a small poodle may theoretically need just as much exercise as a larger poodle. They're just easier to handle to provide it.
I had a mini mix in a small two bedroom apartment. No yard. Minimal walking, because the area wasn't good for it. She did perfectly fine. When she wasn't napping we were playing fetch on a long line out back or in the apartment itself. She did her zoomies twice a day around the living room. We did a lot of mental activities and training. If she got hyper i could pick her up, she would calm down.
In comparison, my standard..... even with a yard and daily walks, regular hiking, etc, gets the zoomies indoors and almost knocks over my recliner. I have bruises from being run into. I'm surprised my furniture is still in one piece. Especially now that he has a puppy to play with. He played with Kiley but not to this extent, they are just... wow. Worse now that my yard is not usable (neighbors trees are suddenly producing berries and attracting lots of bees). So... i love standards and love my boys, but if you're not ready or able to do a ton with them they might be a bit too big.