For what its worth, Charlotte's brand new downtown ballpark has a great view of the NS main on the third base side. I may have been more excited by the mixed freight passing by (with UP power) than I was by the Knights first run in the new park. This strtch of track can see a couple trains per hour, plus you can drink beer while watching freights roll past.

It seems rare to see trains -while- watching a game (you can see the same NS main from Panthers stadium, but that is from the concourse, not the seats). Are their any other ballparks well suited to railfaning?

I'll give an honorable mention to Camden Yards for the amazing C&O Warehouse (but no tracks are visible).