At Flanagan's you can get a seat right in front of a giant flatscreen, right in front of the beer taps, right next to the kitchen. It works for me.
Also, the Dundee Tavern seems to have more tvs than chairs so you cannot miss a pitch. They have really good food too.