Yes, people who are negative about Vista certainly seem to like what they see in Mojave a lot better.
You can check it out for yourself here:
http://www.mojaveexperiment.com/?WT.srch=1
I'm manifestly a video professional, and on all my hardware I've acquired since Vista shipped, I find Vista a better OS. While XP certainly can work on less powerful machines, any machine capable of running current generation video products well are going to be more than enough to run Vista.
And Vista doesn't use any more CPU power or memory for the same stuff as XP; an application uses what it uses. Some people have gotten confused by looking at Task Manager memory use in Vista, noticing that after the machine has been used for a while it tends to stay at around 50%. This is a bug, not a feature; it's keeping recently used files and applications cached in RAM in case they get used again. But that memory is immediately surrendered to any app that needs it. And if you're using Aero Glass, Vista will use less CPU, since all GUI rendering gets moved to the video card.
That's not to say that you didn't have a bad experience; if you were using an app that hadn't been updated to support Vista, or hardware with an incompatible driver, then you can have all kinds of problems. But those aren't issues with the OS, but with your apps or drivers (which very well may have long since been addressed).
If you can give me some details about what didn't work for you, I'd be happy to find out the status of those.
Ben Waggoner
Principal Video Strategist, Silverlight
Microsoft Corporation
Compression Blog: on10.net/blogs/benwagg/
Compression Classes at Stanford and PSU: on10.net/blogs/benwagg/21622/