I've had maybe 30 911s, 4 were 993s, 1 a 1996 993tt that I miss to this day. Had that car for about 2 years. Phenomenal power rush, way smoother than the 'old' turbos. Typically unburstable feel to suspension, brakes, body fitment, interior bits. Ergonomics pretty dated, but modern HVAC works excellent, as does steering. Far less bump steer than elder cars.
I did NOT like the 'drive block' theft deterrent system that requires you push the stupid key fob button at every start up, rendering you motionless if that battery fails. Most every other driving element after that minimal annoyance was a pure joy.
They DO have their problems, notably premature valve guide wear, so a car inching near 60k miles is likely to need it or to have had it done. This is hotly debated on Pcar sites, but just be safe going in. Another are the turbo bearings, which have a drain back valve that clogs over time, and the galls/cooks the bearings. About a 3grand ordeal, and many people upgrade to 'hybrid' turbos during the fix.
Other than this, they tend to leak oil a bit, which for an obsessive like me is not cool. Yet many just live with it unless excessive. Service records are an absolute must. As is a PPi.
It's a bit of a misnomer to call these 'air cooled' (though not incorrect) when you realize they're really 'oil cooled' and are pretty intolerant of lengthy oil change intervals. Porsches do not suffer being 'overheated' much nor does dirty oil do anyone (including the near microscopic oil capillary lines) any good. Fastidious records of 'on time' oil services are your friend.
The values have remained very solid, actually going up a bit over the last 3 years. Timeless styling, with the best 'rear end' (except for FGT!) you're likely to see in traffic, and typically Porsche quality make these an easy 'everyday supercar' choice. The only way to go bad wrong with your experiment is to pick a needy car.
Best wishes. Hope this helps.