I also have the 2006 Mac Pro (upgraded with GeForce 8800 card). Aside from not being able to upgrade the OS to Mountain Lion, my biggest annoyance with it is the slowness in launching iTunes and iPhoto (15K photos).

Have you noticed any improvement in launch time for these apps?