One Click Sound/No Crank When Engine Temps Are Warm

Likely just the starter solenoid getting heat-soaked from the nearby headers, or its contacts are just worn, or a combination of the two. You have a 27 year old car so a worn-out solenoid is pretty common, not exactly what I'd call 'garbage.' You could tinker to see if you could disassemble and clean the solenoid contacts, and if your headers are really close consider some heat-shielding, otherwise it's probably new starter time (brighter side they're relatively inexpensive). Hopefully you're not in the rust-belt like me, those bolts will have welded themselves to the aluminum pretty solidly by now if you are.