All of those symptoms you just descrbed: The I/O errors, the click of death, the need to rebuild the database... All of those can be caused by an intermittent connection between the motherboard and the drive. So rule out those problems first before assuming the drive is bad.

Drives can, and do, go bad, so it may be time for an upgrade. But definitely check the usual stuff first.