English Springer Spaniel (Chewy) lots of drive definitely needed more exercise. I would say he would hunt any bird (grouse/ducks/pheasant/geese) and maybe rabbits but I don't think I would try him on anything else. Mostly because he had no fear and would end up hurting himself.
6 months old 3 grouse
playing fetch to try and tire him out
English Setter (Hershey) more of a family dog but he is fun to hunt with. Doesn't like water and not much of a retriever but when he locks up on point you can see the intensity. I don't think he would be much help on anything but grouse/woodcock. He does need exercise but (I didn't believe this either) he is like a light switch, quiet in the house but outside he turns into a high energy game finder.
first bird
pointing a cottontail on the lawn
first Manitoba bird
I think Golden Retrievers, Labs, Brittanies (maybe beagles?) would be worth looking at. The main thing is to get them from a hunting line, visit the breeder and get a feel for the "fit". Most of these have a reputation of liking their people and are common enough to be able to find good hunting lines fairly easy.
I have zero experience with dogs on big game so can't contribute anything there. The hounds commonly used for raccoons and such are not typically house dogs, usually kept in a kennel and run in packs.
Two pieces of advice that seem to go against each other;
You'll live with the dog 12 months of the year and be lucky to hunt for two so get one you can live with,
You'll probably love any dog you get so you might as well get one that comes from proven hunting lines.
Good luck, hope you find a dog that makes you happy.