I had a my first Henry hoover in 2000. It was a slightly higher wattage than you can buy now (something to do with euro regs) It coped fabulously with a cottage renovation and loft conversion in the deep countryside plus attendant mud, kids, cats and dogs. I even used to hoover the patio with it (there i said it).
It died in 2020 in the middle of another massive house build :(
20 years of hard faithful service.
I was distraught. I reviewed hoovers for hours. In the end we bought another Henry. Again it is my best friend and is currently hoovering up plaster, stone, brick bits, brick dust and torn up insulation ect and leaving the floor clean. Hard floor, carpet or patio.
TIP use it bagless. Keep the big hat like filter in obvs. and when you come to empty the body of the Henry do it outside take the filter out first and beat in violently against a wall or something till all the dust is gone. Then empty the plastic body. Even in my circs. i only have to do this every two weeks or so.
Just get the most powerful you can OP.
Yes, Henry takes great delight in heading straight for anything his rubber bumper can get caught on (door frames is his favourite) and rolls over dramatically for no reason apx once a week, and is a bastard to carry up the stairs BUT you'll never get a suck like his from anything else 
Like you OP i keep hoping for someone to come along and tell us about a fab hoover which is light, preferably cordless but hoovers like buggery on carpet and hard floors and is perfect for keeping upstairs - because i put off carrying Henry up so he's so heavy.
I don't think it exists :(