Actually the 3x3 (two forward, one aft) that you described is quite uncommon. Only the last 3 classes of US battleships, plus the Yamato, Scharnhorst and Vittorio Veneto carry this arrangement (plus a few never built). It did seem to become a sort of "optimum" by the end of the battleship era but it was far from being "standard". The British never built a ship with this arrangement, the closest they got was HMS Nelson.
I would say for "most common" you are looking at four turrets, superfiring pairs both fore and aft, usually twin though sometimes triple and sometimes a mix (e.g. USS Nevada). For me 8 guns in four twins is "standard" since that's what evolved as an optimum at the end of WWI. All major navies had this on multiple ships: Hood, QEs, Rs, Colorado class, Nagato, Bayern, Bismarck etc.
There are so many reasons for other arrangements that this could turn into a very long and interesting thread. Here are a few I can think of off the top of my head:
1) Fire controlThe twin gun was retained for a long time in most navies because it offered advantages in fire control. Most navies at some time or another use half-salvos so they could observe shell splashes between shots without wasting too much ammo. This is incredibly easy to do with twin turrets, no matter how many you have, just fire all the "left" guns, then all the "right" guns.
2) Damage limitationFor a long time there were many who opposed triple turrets because of the fear that a single lucky shot could take out three guns, as opposed to just two. Similarly, two triple turrets next to each other could both get taken out by a single shot, and that's 2/3 of your armament gone. Ultimately the weight saving of having more guns in each turret won out, but there were many ships built just before WWI that avoided superfiring turrets in various ways for this reason, to spread the turrets out.
3) Construction/engineeringThere are also significant construction challenges and complications in making triple turrets. Many navies (British included) had issues early on and avoided them because of this. It also weakens the ships structure because you need a wider barbette = a bigger hole in your deck so something else needs to be stronger to make up for it. There are a lot of complications.
4) Space and accuracyEarly triple turrets were also very cramped and I think in some cases led to issues reloading the middle gun. Another problem is shell interference. The US in particular found their triple turrets very inaccurate because the shells would overtake each-other in flight so close their wakes pushed each-other apart. They solved this eventually by delaying the firing.
Just a few more thoughts for you there
