This car is about as much fun as a 4 cylinder can be. Plenty of punch between 3 and 5000 rpm. I recently drove the 710 miles between LA and Medford OR and got 33 mpg going 80 w/AC on! Amazing for a car with 133k. Drives tight, 5 speed is a must have if you want the fun. Excellent aftermarket support as well. If you get a chance go for the GSR, or, if you're really lucky, the type r (97+). I drove a comparable 95 bmw and chose the integra for reliability, gas mileage, etc., and it is just as much fun to drive with the manual. Overall a fantastic car and you can get a good one for around 4k with lower mileage if your careful.
Manual tranny, SE has type-r sway bar, great gas mileage.