Weekly themes are great for over night camps but I find day camps are best with out them. Day camps the parents are so focused on their kids getting to swim and go on the climbing wall we found anything that took away from the activities hurt us.

Some of our most successful week themes in terms of bringing in campers where:
Sports - A week focused on more physical activities
Arts - A week focused on more art events
Teen - A week for only teens we even had a dance. (This was so popular the next year we added a second Teen week.)