Upright vs. canister vacuum cleaners?

I’ve had both, and find the uprights just too heavy for me, besides the problem of getting into small spaces. But the canisters are awkward too, cumbersome and floppy.

And the little things that are just glorified Dustbusters are handy for quick cleanups, but I can’t do the house on my hands and knees.

I’m in for a new one now and don’t know which way to go. I also don’t want to spend $1000. But I do note that places like Target and Home Depot sell only the uprights. Are canisters just no longer popular?

Advice? Recommendations? Caveats?