For trapshooting a pump or single shot will do just fine, but for sporting clays and skeetshooting an over/under or an autoloader is a big advantage to break them doubles. I use a Remington 1100 for field and skeet shooting, swapping between a 26" skeet choke target bead barrel and a 28" vent rib mod choke barrel.
The Beretta 390 and Browning Citori G_F mentioned are excellent choices too.
I don't think a 12 ga. is too big for any upland bird hunting. Dove are unbelievably tough little critters, and with a 12 ga you get a few more pellets and slightly higher velocity than a 20 ga. But I know guys who use a 20 ga with good success. I know an older gentleman who uses a .410 for dove hunting, but he's an excellent wingshooter. But the downside is that he can only pick close in shots, whereas I can reach out some distance with a 12 ga.