I've never worked there, but I am from the Cape. If you have any questions about the area feel free to ask! It's very different to actually live there than to vacation there. People from the Cape are usually friendly, although we can be a bit hostile towards tourists at times. Hyannis is the commercial center for the region, so you'll be close to the malls, movie theater, restaurants, etc. It is denser than the rest of the Cape, and will have some life during the winter/spring. June-August is the heavy tourist season, and it becomes a different place. It's also only an hour and a half from both Boston and Providence without traffic.
I do know some people that enjoyed working there and they do have a fairly strong union. Get ready to see a lot of geriatrics!!