It's a great inexpensive car. The transmission is totally fine assuming you're not a total idiot with it. I've had my WRX for well over an year and 30,000 miles and no problems. The small issues I did have have all been very easily and quickly resolved via the warrenty on a mildly modified vehicle.

The only thing I regret is not getting the wagon. It's much more practicly as the seat does not fold down on the sedan.