AirRAM Platinum (AR46)

That budget is tough. Cordless vacs at or below the $200 mark are rarely very good, or have a lot of compromises. And to be honest, few cordless options are going to be particularly durable. 2 to 5 years is average (according to dyson themselves anyway). For example, I like the gtech airram models as budget choices. Good for carpet and floors, LED lights, fits most of your criteria. But they are floor-only, and do not convert to a handheld. That would be the compromise. I'd avoid shark, if you weren't happy with the v12 a shark isn't going to be better. Especially not the models in your price range. Similar build quality issues, worse performance, more maintaince required. The LG Q3 is a good choice but it's closer to $300 I think you'd like a miele cordless but those start around 2x your budget.

The Gtech Airram is great but has no tools. Otherwise, Henry Quick or Sebo Balance A1.

I love my Gtechs and have the K9 AirRAM upright, the cordless handheld and the stick. They're brilliant.

Don't have a shark, have a gtech air ram. Still prefer my gtech air ram over my Hetty. Easier to do quick runarounds with gtech whereas Hetty feels heavy and cumbersome and more of an effort. I also find with the handheld air ram easy to hoover car, rather than plugging Hetty in and getting extension out etc. Hetty is indestructible though, agree with others on here. Have had to replace a few gtech parts over the years.

I've got a GTech and a Bosch. They're both fine, no complaints.

Me too! I've had mine for a decade and it does the job perfectly. I have had to change almost everything but parts are cheap and it just keeps on going. Love it.