I have one. Yes, it is like a super Miata. 2.2 turns lock-to-lock makes it feel like a go kart. Best transmission in the world...I've driven a ton of really cool cars in my life, but the tranny on the S2k is the best bar none...well except for a couple of sequential boxes sold in Bimmers and Ferraris. A Miata shifter feels long and vague after driving an S2k.
Now the bad parts:
Not much torque to the wheels at low RPM means that even normal easy launches are a clutch slipping ordeal.
When out of VTEC (V-TECH is a phone dammit), the car is Clark Kent...Superman does not arrive until after 6000RPM (he stays till 9000 in the 2.0l car and 8000 in the 2.2).
If you enjoy modding your car, the s2k will frustrate you. The F20C (or F22C if you are getting the '04+ car) engine is pretty much maxed. CAI/header/exhaust might get you 10hp total...and you will have dropped $2300 in the process. The best mod is a supercharger or gears. Though going forced induction means a lot of other upgrades to keep the car reliable.
The gearing is such that at highway speeds in 6th gear the rpms are a little annoying. The bad thing is that for performance the car really needs shorter gears. Stock is 4.10...a 4.44 is better and many folks are going up to 4.77!
The car handles great on the autox course. But it is one of the most challenging cars I've ever driven...and that includes some very ass-heavy P-cars. You screw-up in the S2k and you will see snap-oversteer that would frighten even a '78 Porsche 911 Turbo driver (and I can tell you first hand that was an evil car). Any autox where at least once an s2k does not end up in a spinning cloud of dust and tire smoke is rare. If you drive the car perfect, it will amaze you. If you f-up...watch out.
There are a ton of little quirks...the radio sucks...if you use any street tire other than OEM, the handling will severly suffer...it is designed for folks less than 6' tall.
Best advice I can give is to get on s2ki.com and read for a bit, but ask me if you have any specific questions. (I sure wish private messaging was enabled here...on s2ki, I am negcamber so you can PM me there)
Are you thinking new '04 or a used 2.0l car?