Stadium (-) numbers for 1b will help a pitcher's batting avg given up line (lower it). All other stadium categories (2b, 3b, LF, RF) will affect pitcher's batting average and slugging given up.
The extent is difficult to predict.
I like pitcher's parks because outstanding pitching seems difficult to find and develop. Also, since pitchers age more gracefully in the sim, owners tend to hold on to the great pitchers until they are in their late thirties so they are rarely available unless you overpay. Also, it seems that finding a decent hitter or fielder to plug a hole is a lot easier than finding a good pitcher to fill a hole. So, on average the quality of the lineup/Fielding is better than the quality of pitching. The extent of this depends on the World you're in, but in my experience, it is nice to give my pitching staff a stadium boost. Even if my hitters get nerfed in the process.