I had a laptop with it and the experience was not great at all, in fact, it was better off with XP instead.
I guess with Vista SP2 it was indeed a great OS, except for the fact that was too late for most people as the damage was already done.
By the time they'd release Vista SP2 there was a superior Windows OS: Windows 7
Windows 7 was so good it felt almost perfect and unbreakable. Are newer Windows OSes better than 7? No.
Oh man Vista would melt a laptop, I mean literally... The Dell 6400 I think was the model at the time... We had to quietly recall them if customers complained about heat issues we would no questions asked just send them a box to ship it back. I had people calling in complaining they ran so hot they couldn't type because the keys where about burning them.