Hi Brad and welcome to the board. You'll find that everyone loves the TSX and just about everyone feels that the auto version is a bit short on power, but you can test drive it yourself for that.
The 2.4L responds very well to aftermarket modifications and you can easily get 15-20 horsepower from basic bolt on modifications.
FYI, the MY2006 version will have about 10 more horsepower.