Not blockbusters, but I really enjoyed The Rundown and Walking Tall. He was good in Pain & Gain and Hercules, and definitely wasn't the reason those weren't good movies. Shit like Tooth Fairy and The Game Plan is really no worse than Kindergarten Cop, Kindergarten Cop just has a funny sound board because of how bad Arnold is with English. When he did the Ladies Man skit in drag on SNL, I about pissed myself laughing.
Unrelated to The Rock, The Longest Yard is a great example of pro wrestlers being great on screen. Kevin Nash in particular, once they swapped his pills, was fucking hysterical.