Technique is everything.
I see people on YouTube that are swinging that vacuum so fast, you would think you were on Indy.
Slow down, give the machine a chance to work, and you can get good results from an upright, power team, or straight suction machine.
My mother had a good friend for many years, up until her death, that cleaned her home with a straight suction machine. An Electrolux Model G. I would dare you to have found two grains of sand in her entire home.
Edit to add:
I want a Henry, but it will have to wait, unfortunately my check book says I have been buying too many vacuums lately. (I just won an auction on another Filter queen, a 360 for $66.) I have been on a Filter Queen kick lately it will be by fourth.