I recently got a del Sol and I love it. Of course, it is not my only car though. I don't think that driving other people around or rather not being able to do it would be a huge factor for whether or not I buy a car. But... if you are used to hauling people and stuff around, I would not. It is very roomy for one or two, and the trunk is very large. The trunk in my sol is more functional than the trunk in my S2000.
I would advise you against financing a car that old though. Chances are that any Honda will be at least slightly overpriced, and after you factor in financing charges on a car that old, you might pay twice as much for it.