Was your coolant filled to the normal level? If you had adequate coolant and it never showed overheating on the temp gauge, your engine should be just fine.
The “steam” from the front probably wasn’t coolant, it was probably the spilled tranny fluid that reached a temperature where it could combust. Tranny fluid, which is oil, can burn easily if it gets on or near the exhaust manifold. This will create smoke that you can see.
Sounds like this “local shop” really did a lousy job. I wonder if they used a transmission fluid that’s not compatible with Hondas. Honda requires a special kind of transmission fluid. Find out what they put in your transmission.
When your car lost acceleration and RPMs went up, sounds like your transmission was slipping. Not good. Could be from the wrong fluid. Or overfilled fluid that gets aereted.
If they ruined your tranny, their insurance company should buy you a new one. Document everything that happened and what they did. Get an inspection from a good independent mechanic. You may have to pursue the “local shop” through the legal system if they screwed up.