The sight lines and intimate experience are definitely a plus for once you're inside the stadium. If they weren't having to accommodate the collanades they probably could have done a better job with concourse, exits, and such. But you can't add 20k seats and keep what's good about it currently.
It's still a really terrible site until they come up with a solution to make the Metra tracks as the main public transit source into the stadium area including connecting the other nearby transit options in a low hassle way. Roosevelt stop just isn't very close or convenient at the end of the day (if it was a straight shot maybe, but it can't be). Obviously by car the site will never be good, which would be fine if the public transit wasn't pretty meh too. And yea, most stadiums suffer from congestion, but SF has always seemed particularly weak in that department, even for less dense events.