Since you mentioned waterfowl, I would look at 12 gauge. It is an all around shotgun load with many, many different shells available.
As for specific guns, I like autos--Benelli and Browning. The Browning A-5 has a gas ring that changes the recoil cycle depending on heavy vs. light loads to eat up recoil. Can usually find good deals on them.