We have a central vacuum at home. We’ve had one in all 3 of our homes. LOVE IT, works better than any other vaccum I’ve ever seen and it’s a help with my son’s asthma. However, it’s not exactly cheap and while lightweight, cutting sheetrock and installation is probably not what you’re looking for!
We also have a stick vacuum in the kitchen for easy after meal clean-up. We have the ErgoRapido. It’s battery operated, does a good job and is easy enough for the four year old. However, it won’t do whole house cleaning.
For our homeschool co-op, I bought an Oreck. It is an upright, but is extremely lightweight and works wonderfully on the carpet! No attachments, though. This thing cleans many classrooms after co-op each week and the church uses it after all services. It’s a workhorse! I can’t speak to how it does on other surfaces, but it may be an option worth checking. I bought it at Target.
Can’t help with canister vacs. Haven’t had one in 12 years, but when we did, it was a Kenmore. I found it cumbersome, but it did clean well.
Christie