I upgraded the 320MB 5400rpm Hitachi HTS543232L9SA02 drive to the 500GB Seagate Momentus ST9500420AS in my Macbook Pro (2.66GHz Core 2 Duo). Technically it works really well, no hiccups with the installation, no heat issues even when working hard, and the system feels more nippy (I use things like Photoshop, VMware Fusion etc.).
"xbench" (a free Max benchmarking utility) now reports a "Disk Test" score of 52.6 (vs. 33.7 for the 5400rpm drive). Sample xbench results show a much better performance increase than expected:
Sequential
Uncached Write 256 MB blocks: 78 MB/s (vs. 40 MB/s for the 5400rpm drive)
Uncached Read 256 MB blocks: 80.6 MB/s (vs. 41.1 MB/s for the 5400rpm drive)
Random
Uncached Write 256 MB blocks: 52 MB/s (vs. 20.7 MB/s for the 5400rpm drive)
Uncached Read 256 MB blocks: 26.2 MB/s (vs. 13.2 MB/s for the 5400rpm drive)
Unfortunately the drive is a bit more noisy than the Hitachi, the normal "disk spin" noise is not too disturbing, but the drive vibrates a lot more than the 5400rpm Hitachi. You can feel the difference when you hold the running drives in your hand, and that vibration causes resonance at least in my Macbook Pro (aluminium body) which is very irritating.
So from a performance point of view an extremely worthwhile upgrade, but be aware that this drive might come with some noise penalties, which very much will depend on your system.
Note that the drive comes in different versions and cache sizes, the more expensive "ASG" means it has shock protection, my Macbook has that built in so the normal "AS" version was sufficient for me.
NOTE ADDED 27 May 2010: I just replaced this drive with a Hitachi 500GB Travelstar 7200rpm drive, not because I'm unhappy but because I need to test disk encryption software for work and clone my drive between the tests. I thought I'd post the results here. The pro of the Hitachi drive is that it is dead quiet compared with the Seagate, no annoying vibrating "hummmmm" from it. The drawback is that the Seagate is a bit faster. xbench scores the Seagate at just about 10% faster in all it does.