I have always.. ALWAYS.. hated laptop trackpads. They were a sub-par mouse replacement that only served to move the pointer and failed to add any functionality. (coming from a PC environment)
That said, I absolutely LOVE the trackpad and multi-touch features of the MBP. The two-finger scrolling (not new, I know, but new to a switcher) is the most useful input feature in years. I also like the ability to change font sizes in Safari by the pinch/stretch method. I have not used the rotate much, only when converting digital photos taken on my camera and orientation change is needed, but I agree that in that instance the size of the trackpad is a little annoying.
The first day or two I was unintentionally using some of the gestures but after a week of use, the trackpad has become totally intuitive to use. I purchased a wireless MM due to my previous dislike of trackpads and I haven't used it once.