Firstly from http://forums.fedoraforum.org/showpost.php?p=1114769&postcount=1:
su
rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm
yum install kmod-nvidia xorg-x11-drv-nvidia-libs.i386 xorg-x11-drv-nvidia-libs.x86_64
reboot
Then of course I wanted the CompizFusion desktop effects.
From http://www.fedoraguide.info/index.php?title=Main_Page#Applications
su -c 'yum -y install compiz-fusion-extras libcompizconfig ccsm compiz-manager libcompizconfig'
su -c 'yum -y install compiz-fusion-extras-gnome fusion-icon-gtk'
compiz-manager
This took my Fedora 10 out the box, from being pretty good to looking flippen great!