Welcome. Automatic can take some of the fun out of a 4 cylinder but of the 3rd gen options the 4t40e that you have was the better one. Regardless, a relatively cheap and easy way to make this car fun is below:
Supercharger Guide
"In Oldskool we trust"
Welcome to the community mate. Nice to see you here. lol