Usually when people set me up for high expectations, I end up getting disappointed. In the case of the Macbook touchpad, my expecations were actually exceeded. I use Bootcamp a lot for some of my projects, and the touchpad support in Windows is so bad, I can't wait to go back to Mac Os (other than that, I'm pretty much OS agnostic).
There's now a 3rd party precision touchpad driver that works surprisingly well for MacBooks. Unfortunately it's CPU-bound and high CPU load can cause the touchpad to be unresponsive. Setting CPU affinity to high partially mitigates the problem though