I have an nVidia card with 128 meg VRAM and the proper drivers installed. I'm running Compiz with desktop effects with no trouble whatsoever. HTH, HAND, but remember, AHS and all that jazz.
Registered Linux user #470359 and permanently recovered BOFH.
Any advice in this post is worth exactly what you paid for it.