as a friend said once, "when the thing spins down all hell breaks loose"
Basically, I take this as an example, some place loaded with servers, one day the power goes out and the UPS fails, and a machine that was never turned off and had been running for like 10 years had hard drive failures left and right.
Hard drives are a back and fourth thing, on a laptop you want to keep it between what's safe for the drive and good for the battery. Remember though, spinning up and down hard drives eats up battery power.
On a desktop drive, I'd say keep the thing spun up as long as you plan to use it, then let it go to sleep, if you get the idea, desktop hard drives are made to sit running and being used maybe 4 hours at a time, then sleeping, or etc.
Either that or used 24/7.. I haven't let the HD in this computer be off for more then 30 minutes in months.
Then again, that's because I use the machine as a server lol.