I look upon it as a good sign when the hard drive does absolutely nothing when it is connected because that means the circuit board might be the problem, and that is a relatively minor fix. Hard drives that are clicking or noisy usually mean an internal problem. Internal problems like platter motors and heads/actuators take some skill , and preferably a clean room, to fix/swap.
Working on the assumption there is a problem with the circuit board, try to find a replacement hard drive. Same model for sure, preferably with the same firmware as printed on the tag/sticker. Not sure if Seagate keeps the firmware on non volatile RAM on the circuitboard, or whether it is on a section of one of the platters. I am sure a pro will be along to offer better answers. If it (firmware) is kept on the platter, then as long as you have the same circuit board, you are in business. Swap circuit boards and cross your fingers.
Internal problems, on multiplatter drives are a PITA to fix. Once you lose platter alignment, kiss your data goodbye.
Before you get too involved, ck the simple stuff like the SATA power connector. Verify there are no cracks or peeled traces. They do break. Look for any signs of burned/overheated components on the circuitboard.
I have been fortunate. I have recovered 2 drives by myself via swapping circuitboards (thanx Ebay), and have had to send off 2 (maybe 3 now) for clients for a "professional recovery". Pros did their job, expensive as hell, but they did their job.
Oh, you might put it in a plastic bag and freeze it overnight and try to spin it up. Keep the plastic on it so you don't run into condensation problems. Works sometimes, and its cheap to.
EDIT 2: Possibly:http://www.donordrives.com/seagate-750gb-st3750330ns-fw-sn04-100468979-g-sata-3-5-pcb.html
Edited by dpunisher, 13 June 2013 - 04:16 PM.
I am a retired Ford tech. Next to Fords, any computer is a piece of cake. (The cake, its not a lie)
3770K @4.5, Corsair H100, GTX780, 16gig Samsung, Obsidian 700 (yes there is a 700)