I have owned Weimys for a long time. The first thing you should know is that they are as human like as a dog can get, by that I mean they are very hard to deal with if things aren't the way they want them. They tend to be vindictive and almost all suffer from separation anxiety. Thats a bad combination because when you leave them alone, they destroy your stuff out of spite.
On the good side the human like qualities are amazing and when properly trained they make outstanding companions. Loving as a dog can get. They have to be with you always and don't take no for an answer. When your seated they will sit along side you and have to make contact with you in some way.
As for hunting, I have had both show and field dogs. I will say, and this not being an expert opinion, They would not be a good water dog. The most obvious thing is the short hair. Keeping warm would be a concern. and additionally I have never owner a weimy the could swim a lick. I mean mine would sink if they were out there too long. Talk about a doggie paddle, the only thing out of the water when my dogs were in it were their heads. I seriously thought they would drown. Great pet, very rambunctious, great at knocking little kids over lol... So to answer the question, get a lab
This is what a weimaraner does best, lay on the couch