Bigger ports are more efficient, too a point.
Its hard to say how much is too much, but yes more port area = more SPL, until you get to 'too much'
'Too much' is very application dependent. Also, the more port area you have, the less effective your box will be when you aren't near the tuning frequency, and it'll act more like free air
Most I've ever used so far is cone area = port area, and it did exactly what I expected it to, so that's clearly not 'too much' at least in my application. I intend to use cone area x2 for port area on a test box for a 10" sub in a couple days to find out if that is justifiably 'too much'
Eventually you basically will get to a point where the sub cannot pressurize the port and will act like it's in IB or free air
If sub is excurting 2 inches peak to peak, and port area = cone area, that means the air in the port is moving 2 inches peak to peak (at tuning frequency). If we halve the port area, it must now travel 4 inches peak to peak, and increase port noise as well as cause more of the pressure to be lost through friction. Think of the port almost acts like a hose in this manner.
The bigger the port, the less pressure is lost due to friction, because the speed of air movement is significantly decreased. The less pressure is lost to port friction, the more output there is.
Edit: sry this post wasn't more organized..kinda just typed as I thought of how to explain it