Around here the main waterfowl are wood duck, mallards and canada geese.
I use #4 steel if I know it will be woodies, BB if I know I'm shooting geese, but since I'm likely to see any I usually split the difference and load #2 steel in the magazne. Not the best choice for any, but will work for any.