I've been switching back and forth between SUSE 10.0 and Ubuntu 6.04. However recently got the XGL + Compiz effects working in SUSE and was completely blown away. Note: It does appear to heat up the graphics card a bit as I havent found a good linux fan control..
In case you haven't checked out the XGL effects, here's a video clip of the demo. http://www.dailymotion.com/video/44821