Is there something that Bay does contribute to movies? I mean, could a really good movie theoretically have Bay credited as, I don't know, Chief Explosion Wrangler or something?

Sure, no-one wants him to direct or being in charge of the writing team, but apart from that...?