I have had Windows XP and Ubuntu installed on 3 different computers, and I have always found Ubuntu to run faster than XP, even though I had my XP tweaked to use only essential processes on boot up. Forget about Vista. It is way more bloated and resource intensive than XP, especially with those aero glass effects.
You are right though, Ubuntu is getting a bit bloated, and the article I gave a link to in my 1st post in this thread confirms this.
You can disable the compiz and composite effects in Ubuntu if you want. I do. Also, there are many other distros you can try if you don't like Ubuntu. You will always have that choice with linux.
Perhaps you should have a look at Zenwalk. It is a full featured and up to date distro, yet it runs very light and fast. It is quite easy to install and use too.
http://zenwalk.org/