The most we spent was about $600 per kid per week which was all day and included a door-to-door bus service. That was 2-3 weeks maximum however.
This year we're spending about $200-$350 per week on a variety of camps (no bus though).
For 2 kids and about 6-8 weeks it does add up but is less painful than $600 per week.