After practicing straight pool on my 9 foot home table with 4 1/2 inch pockets for a few months lately, I can tell you that way too many shots rattle out of the pockets for my liking.
I think that I recall John saying once that he had around a 200 ball run on something like a 4 1/2 inch Diamond and that he felt that was a bigger accomplishment than his 400 ball run.
To me, straight pool is about running as large a number of balls as possible, so I tend to agree that really tight pockets takes away from the thrill of the game.
He had a 294 on a Diamond. Not too shabby. Highest run on a diamond that I have ever seen.