I used it for a brief time period after SP2 dropped, it was alright. They've ironed out the kinks by that point, and general consoomer hardware was able to handle it too, so it was a pleasant experience.
Unfortunately, they were too late - the damage was already done. Its reputation as a buggy resource hog persisted (despite the fact that 7 required more resources), and nobody really cared anymore. So mainstream support ended soon after that, and because of that hardware and software support for it is about on the same level as Windows XP.