I can tell you with 99% certainty that you're not going to find a stick shift rental in the US, at least not at the major agencies such as Hertz. Disappointing to people like you and me who prefer a manual transmission, but such is life.