Well lo and behold..I actually got the bloody thing working. Replaced the older kexts from 10.4.6 with the newer ones from 10.4.8 and reinstalled NVinject and bingo, QE/CI, and rotation. No tearing, smooth as silk. Guess it does help to do your own research.

---

OS : Snow Leopard 10.6.8
Motherboard : Gigabyte GA-M68MT-S2
CPU : AMD Athlon II X4 645, 3.11 GHz
RAM : 4GB Crucial PC3/16000 DDR3
GPU : nVidia Geforce 210 1 Gig Full Hardware Acceleration
Sound : Onboard Audio Realtek ALC887
LAN: Sonnet Gigabit PCIe Ethernet Controller
Monitor : Acer S231HL 24" Wide Screen 1920 x 1080 @ 60 Htz
USB: Keyboard/Microsoft Confort Curve 2000 - Mouse/Logitech M185
Bluetooth: Apple Magic Tracpad/ DLink DBT 122 Bluetooth Dongle