I think tight pockets are a valuable tool, but aren't god's gift to concentration and shot making. If you want to play pocket billiards on a super tight table, go try your cue at snooker.
One of the things I know about pool is that it's designed so that (in 9-ball anyway) you almost always have a shot -- be it a thin cut, running it down the rail, long and straight in, a carom, combo, cheating the pocket, etc. It's not like snooker, where cutting a ball down the rail is near impossible and generates enormous applause.
But I do know that playing on a super tight pocket table like the picture I posted earlier makes you a LOT smarter in position play. You avoid getting on the wrong side of the ball at all costs, because any fance position work to compensate will usually result in a miss. If anyone's seen SJM play, he really does make the game look easy (as opposed to my game!). Playing on tight pockets forces you to play like this... easy, makeable angles, right side of the ball, etc etc.
At the same time, I do agree with the likes of Lassiter (hard not to!) in that you have to play on a reasonable table to let your stroke out. It's hard to get in the zone and freewheel for a bit if you're afraid to pull the trigger.
To each their own, and to some,... both!