Yes, details on what you're looking to get out of your car purchase would help. Mine has been my only car for about 8 years now (picked up a second, 'bigger' car that will be on the road soon, though), and I have no regrets and currently no desire to ever get rid of it. But I'm also not hauling other people around either. Back seat head and leg room is really only for kids, but it's better than other coupes I've been in.
The '05-'06 seats are more bearable for long drives; I prefer the look of the '02-'04, so I had to swap those seats in. Stock suspension is a bit stiff, so look elsewhere if comfort is a high priority for you. It's not horrible, just... "sporty." Test drive on rough roads, for sure. Personally I like that kind of thing. I've done some mild upgrades to the suspension and it's been huge fun around roundabouts for the drive to work and in the mountains. I've got a spare set of wheels with dedicated snow tires, and it's fantastic in the winter (I'm only lowered about an inch and a half). Reliability is typical Honda; mainly just keep up with oil changes. Mine's coming up on 280k miles - these are older cars now so expect to have to replace things like the starter or a sensor here and there before too long.
One of my favorite aspects of the car is that the rear seats actually fold completely flat:
This shot is coming
home from the tire store; these wheels and tires also fit back there
before mounting - the bar is aftermarket, ignore that:
I can also tell you that the car's own hood (say, if you buy a carbon one off Craigslist, haha) or a 55" TV in the box will also lay down flat back there.
