I had an 09 TSX sedan with the 6spd. Only thing to really watch out for is oil consumption. Acura rolled out a TSB a few years ago willing to do tests to see if your motor qualified. Value on these have really tanked since Honda/Acura killed the TSX/TL in favor of the TLX.
Always wanted a TSX wagon with the V6, but alas, no. Throw on a modulo front bumper and they look pretty sweet. Go all out and put on a Mugen front bumper if you have the funds/mod bug/like to stand out. The 2nd gen TSX K24Z3 doesn't get much love (fake vtec) here in NA, but they have quite a tuner's following in Europe.