[VPRPWRD]

The only thing I can think to do ( AND PLEASE SOMEONE STOP ME IF THIS IS BAD) is while the clicking sound is happening, one by one remove fuses and or relays until it stops. You have a 04 RC so its a stick and shouldn't have any solenoids in the tranny so what I thought originally is useless. But please someone chime in if that's a bad idea. Just don't yank them all out at the same time

That is a good way to do it, it isolates the problem to a circuit and can continue diagnosis with that one circuit.