It really depends on your needs, priorities, and duration. Some Cape Cod hotels are under $100 a night while others may be several hundred. All in all, most families typically spend at least a few thousand dollars for a week-long family vacation in Cape Cod.