I own a 2005 TL 6 speed and I very much love it. There are so many great things about the car that add character to it. Autos have tranny issues. Go with 6spd if you can. Its def reliable and when you DIY you save even more. Power is there. VTEC is not loud but adds a punch. Also with them being Hondas, many parts can be had for dirt cheap.
6spd= Brembos in the front+thick a55 front upper strut bar+firmer suspension.
Yea it is front wheel drive but nothing is stopping you from staggering it anyways. Acuraziners do it all the time.
Best bang for your buck imo.
If you have anymore questions in detail about the car. Feel free to ask or pm me and I would be more than happy.
PS. Type-s does suck on gas. 23mpg sounds about right. I get around 28 with 60% highway / 40% city