Been driving a base 5-speed RSX for nearly 10 years. Bottom line, for what the OP is asking (99% DD/Fun, 1% HPDE) this is a brilliant car. Sure, the Type-S gets the glory, and there are times I wish I had that extra 40 HP, but I actually prefer the 5-speed gearbox and base stereo flexibility. Throw in the difference between buying 87 instead of 91 for 10 years, better MPG, and insurance differences, and the 40 HP starts to get trivial real fast.
For HPDE, this was widely praised as being the best handling FWD car ever tested by numerous mags when it came out. I've helped mine out a bit more with a front strut bar. For pure tracking, the rear geometry is a bit lacking when you get into lowering the car, etc... but that isn't what the OP is talking about.
The seats are also great, despite what BenB seems to claim. It sounds to me like he was driving in a poor biometric position. The lateral support is exceptional for HPDEs.
The downsides are obvious. It lacks low RPM power, so you have to be in the right gear all the time if you want throttle response. It also has a bit of a blindspot on the driver side, but the mirrors do a great job of minimizing this. It is also a bit bland in styling as a stock model. I, however, got mine with the factory side skirts, aero front and rear, and spoiler. Frivolous, perhaps, but it is a damn good looking car with these options, while still looking mature enough to outclass the fast and furious wannabes.
My recommendation is if you can find one that has been babied for under $10k, buy it. You won't regret it.