i used to drive a 1996 grand am, with the 4 speed automatic and a v6. now this is likely either the same or a very similar transmission as what was in my car. I actually had the transmission replaced, but here is what was the problem i my car:
Attached to your lock-up torque converter solenoid is a valve. It is made from aluminum and to be honest, i can't remember whereabouts it is located, because it was a while ago and i only looked at it a few times. Anywho, this valve has something of a little piston inside of it, also made of aluminum, and over time both the casing and this little piston sort of thing will wear out and start to get stuck. Once this happens, your torque converter will engage/disnengage rapidly. Yhe torque converter is what helps the transmission to go into overdrive when you have stopped acclerating and are trying to hold a constant speed. In my car, this revving problem was most prominnt when i was going up a hill, or around a corner, because the car was nto sure if it should gear down or not. Eventually, this problem will worsen, and the car will not go into overdrive, and your engine check light will come on. The lack of overdrive will occur when the car is hot, and the valva has expanded and become stuck, and the revving happens when cold, and the valve is sticking/unsticking repeatedly. Furthermore, the car will burn about 1/3 more gas if it cannot overdrive because at 50 mph you will be at about 2300-2500 RPM instead of 1700-1800. In the advanced stages of this problem, the car will begin to stall out when you stop etc., and the revving when cold, sticking when hot will get much worse. Take it to a chop and sugest this may be the problem, and they can check it out. I never had mine repaired, but a gentleman i know had this repaired on his GMC Jimmy when it displayed all of symptoms and it cost him $500. I believe on some vehicles the valve is on top of the transmission, and the trans must be removed to access it. If not it is an easy fix. What should be done, is that the valve is drilled out, and a new one, made of much higher grade aluminum is put in it's place. Post back with anymore questions, I can probably help, I spent a lot of time trying to figure this out on my car and I learned a lot in the process.