I have a 1.5TB Caviar Green in my MythTV box and it's been running for a few thousand hours with no problems. It's only 5400rpm, but I don't notice it feeling slow for anything I use it for.
Ultimately, as mentioned, if you really want good performance you need an SSD.