The (current) stadiums Ive been to are:
1) Target Field- beautiful skyline and very modern stadium.
2) Suntrust- Im still more of a fan of Turner, but this is still really nice
3) Kauffman- lots of great parking, fun atmosphere, but the stadium rally needs more renovations than just the fountains
4) Nationals Park- total dump with hardly any real baseball fans. The area it is in is nice, but the atmosphere and how that stadium is built is horrible
So no I haven't been to Tampa's stadium, but with the Dodgers, Braves, and Nationals you would have to feel that there are going to be a lot of for sure homers hitting those catwalks, and just resulting in wasted time and ground rule doubles like it did in the last WS they hosted.
Ive heard PNC and SF's ballpark are the two best in the MLB.
I agree totally on Target Field....though as snow is encroaching on the state this week, it's a good thing the Twins lost.
Places I've Been
Atlanta Fulton County - just a stadium
Turner Field - it was okay, but boy did you seem far away from the field
Oakland-Alameda - the worst aspects of the above two stadiums
The Trop - just an ole ballpark
Globe Life (Rangers) - was in fact at the finale two weeks ago; serviceable, adequate, hotter than hell in the summer time
Busch - went twice, overall good experience (sports bars across from the stadium are becoming the norm some places)
Fenway - it was built during the Taft administration; the ballgame experience is great but the park itself is incredibly overrated. Some of the seats are looking into foul territory as opposed to the field (so you look crossways). Seats are also incredibly small and built for the world of 1912.
PNC Park - that absolute best; the scenery changes every inning during a summer game with the sun setting, and the Clemente Bridge is something totally different - like the Grand Canyon, you have to actually see it (yes it looks nice on TV but far better in person).