I have a Hitachi Travelstar 5K160 (160 GB 5400 rpm) in my MBP, which I installed myself about a year ago to replace the stock drive.
I am pretty sure that the same noise we are all talking about was not present during the first months of use. I am less sure whether its appearance a few weeks ago coincided with a system update (namely 10.4.9 to 10.4.11) or not.
For those of you still unsure, this noise (that I would describe more like a "pfuiit") is definitely related to the drive parking its heads.
If you have not already done so, you should absolutely read this thread:
http://discussions.apple.com/thread.jspa?threadID=1001366
especially the posts by Whiskey in the Jar-o and emarmite2.
As they suggested, I have installed smartmontools, which gives you, among other information, the number of load/unload cycles your drive has been through. By running the command before and just after the noise occurs, I could confirm that one occurrence of the noise made the count increase by 1. After a few minutes, the cycle count increased by dozens. My drive is already at 364,000 cycles after only one year of use, and Hitachi gives a reliability value of 600,000...
This is a bit scaring, if one should extrapolate from these figures that my drive will be prone to fail when it will be 2-years old, as all other drives exhibiting the same behavior may see their lifetime greatly reduced.
I cannot understand how Apple can qualify this "normal behavior"??
Have you questioned the support of the drive manufacturers? (I plan to do it.)
From other discussion threads, it seems that the problem occurs with Mac OS X but not when the same computer runs Windows (I have not tested this yet). If this turned out to be true, then it would entirely be Apple's responsibility to fix their drivers or whatsoever.
I have not tried the hdapm solution yet, but I think one interesting question is, if this is supposed to work: which is the best setting to use (from 1 to 254), because we obviously still want the heads to park when it is really required (does the "max" setting may impede them?).