I dont have a TSX but I do frequent Acurazine due to owning a CL. The majority view on the TSX is its an excellent car. There dont seem to be many major problems with these years. Build Quality is great and the K24 is an excellent engine. Its basically a 4 door premium version of the RSX.
Id try to look for the 6 speed but if you cant find one or dont want to drive manual, the auto is good too.