94 is the Series 1 L67.
You should be able to find a used tranny for about $500. You will need a 4t60e-HD if you want to replace it. It could be an simple fix like a shift solenoid, but that still requires the transmission be dropped to access.
Things to look out for:
Supercharger rattle: take the belt off and spin the pulley by hand. does it spin freely? is there slop and play? if there is slop it is probably the couple that is shot. an easy $50 fix.
Leaks: Sunroof, windshield, door seals, etc...
Rust: near the gas filler, in front of the rear wheels, undercarriage, top of the windshield
you have to remember you are looking at a 14-year-old vehicle, and it is bound to have problems. however, most of them should be fixable with the club