I was in the same situation about 3 months when my 12yr old Integra with 220,000 miles started to give me problems. I pretty much made up my mind on getting the Accord based on how reliable my Integra has been the last decade. Just out of whim, my friend of mine told me to test drive a new Altima. I basically told him what the heck was he smoking, why would I want that funky little car? I was totally unaware that Nissan had redesigned the whole car. So that afternoon we went to a Nissan dealership and test drove the 3.5 SE.
All I can say is that afternoon in the Altima change my whole outlook. I was in love with this car. While I was driving the car, the sales guy told me it had 240 horses underhood. I looked at him with a blank stare and gasp, "You got to be sh!tting me! This car has 240 horses!!. He said it sure does. Go ahead and give it alittle gas. So I did. My smile got wider and wider as I was going faster and faster!!! This car is freakin fast!!! Before I knew it I was going 95mph on the freeway. A week later, I was a proud owner of a 3.5 SE.
I say before you buy any car, you have to go and test drive it. Yeah it may sound obvious, but I was all set to buy the Accord without giving another car a chance. Your friend has quite a delimma. All three cars are great choices. I guess it basically depends on whats your friends needs are. If you need a big car and you have to buy one now and you can't wait. I say get the Altima. The Altima, hands down outperforms the V6 Accord. Some say the interior is cheap and I have to say they have a point, but its noway as bad as some suggests. I a few months the 2003 Honda Accords should be comming out and this disscussion may not hold true, but like you say if you need a big car and its between the Accord and Altima get the Altima.
Price wise, you can't beat the Honda's financing since you know they are making room for the new 2003's. I actually got my Altima below invoice price, but you really have to find a dealership that is willing to work with you. The majority of the Nissan dealers are crooks. Don't listen to their cr@p about markup and don't pay anything more than a few hundred dollars over invoice. One dealer was asking $27012 for a 3.5SE thats about $3000 over invoice. I walked out of that place and found another dealer.
The RSX is a different beast all together and I'll let somebody else tell you about it since I basically didn't do any shopping for that car.
All in all, I say have fun with it. Maybe I'll see you someday sucking my exhaust as I blow by you
If you interested, here is a message board where us Altima guys hang out..
Linky