Aero was kind of a mess in Vista, but improved substantially in 7 (and a lot of that was due to more frosted glass look / less transparency). I would still rate 7 as the best balance of usability and eye candy that Windows has ever had, and I've used all of them heavily starting with Win 3.1.