There's a Courtyard but it is not on the water and on the main road which has very high traffic. Most of the hotels on Cape Card are not that upscale. There are some timeshares and other houses that you can rent that are on the beach and a little nicer. But that's the part of the cape that everyone wants - low scale relaxed type vacation. Traffic won't be as bad in September as in the summer but it is still crowded.
Golf courses are nice on the cape if you like to golf. There are a number of cruises fast and slow to Martha's Vineyard and Nantucket - both of which are worth the trip even for the day. Christmas Tree shop is always a favorite of people who visit.
In my view, Chatham (at the elbow) is the prettiest village on the Cape, and one of the hardest to get to in summertime since it's not directly on the mid-cape highway, US Rt 6.
Aside from that Chatham has a lot of charm and great places to stay and to eat. If you can swing it the 100 year old Chatham Bars Inn is wonderful as if the Inn on Little Pleasant Bay, a B&B just outside town. Food is great there: try the Impudent Oyster for seafood, Bucas (just over the line in Harwich) for Italian. Both exceptional and not overwhelmingly expensive either.
Beaches are nice, but before Labor Day there is a charge to park. Mass law allows access to all beaches at the low tide mark, so they are great to stroll along. Ignore the starter castles along the water's edge--those are Wall Street former tycoons anyway and most likely the houses are in foreclosure!
So Chatham is my pick: I even made it the locale for my 2007 novel (composed entirely in a CA full-service Marriott hotel by the way) which is called Stepping Stones.