We've workkamped near Lake George, NY (Daggett Lake Campsites) and in Rockport, Maine (Camden Hills RV Resort). As well as other states. I don't think the location makes much difference - you have to assess the work expected vs the remuneration received, and the desirability of spending months in that area. The most common reason for dissatisfaction among workampers is their own failure to ask enough questions about the work expected of them and the compensation to be received for it.
The premier site for matching campers with jobs is workkamper.com. Good advice and tips available there too. There is a modest fee for joining.