If you have all the money to spend, get a 1.4t and a 6 speed automatic out of a cruze and stick it in there.
If i was going to go all out and swap the tranny i would just figure out how to get a manual in there.. Personally i think all cars are way more fun manual. I only prefer auto in trucks and most SUVs. but thanks for the advise