My kids are still young, so some of my list might not work for OP's 8 year old, but if it's an all ages discussion, I've got a few, some of which might translate to more ages.
Free stuff when weather is nice (relatively speaking, in this unusually hot summer):
- Playgrounds/parks, including splash parks and swimming pools.
- Scavenger hunts on a walking loop: give a list of things to find, either by just seeing and checking off, or things that can be collected (e.g., acorns falling from trees). Combine with farmer's market or other street markets to make the journey slightly more productive.
Free stuff when weather isn't as nice:
- Free Museums, if you have any nearby.
- Cooking at home together. (This is free in the sense that it doesn't cost any more than feeding yourself by cooking without the kids.) Things involving dough or batters are often fun for kids: pizzas, muffins, pancakes, etc. My daughter loves "whipping" cream by putting heavy cream in a mason jar and just shaking it for a few minutes, until her arms are too tired. I also like dishes where they understand every step, even if they can't perform every step involving high heat or sharp objects: fried foods that get battered/breaded before frying, ravioli or dumplings that need to be filled/assembled before boiling, etc. Some steps are more about them watching than them doing anything, but if they take an interest at a young age you might be able to introduce teaching them how at the appropriate age. My kids obviously aren't allowed to touch the controls on the stove/oven, much less the open flame of the outdoor pizza oven, smoker, or charcoal grill, but always like watching me light up some fires. Little pyros.
- Photography. An old unused cell phone might be good enough, but kids can learn the basics of capturing a moment or composition/framing just from the lives around them. My kids have standing permission to take my (locked) phone to take pictures, and I'm probably going to buy a dedicated kid-friendly/rugged point and shoot for them soon.
Low cost activities:
- Art projects at home: markers and crayons, sure, but one-off projects that involve sculpting or assembling or gluing something 3D can sometimes mix it up.
- Some sort of fun musical instrument where the kids can be creative with audio: toy keyboards/xylophones, kid-oriented electronic beat machines or drum kits, etc.
- Museums or other fun places with one-time memberships where you pay once per season/year to go for free each time. Some parks/pools/playgrounds might be privately run, but could sometimes be worth the cost of a season pass.
- Car camping overnight in state/national park areas. Work in a few day hikes and other outdoor activities, make a thing out of setting up the shelter/tents, maybe starting a fire (weather and location dependent), making smores or other camping friendly food, etc.
Higher cost activities:
- Hotel or house rental near a beach or lake, with beach activities during the day.
- Sending them off to visit out-of-town grandparents and other family (or hosting family to come visit). A big part of the fun of summer camps is the people anyway, so giving the opportunity to interact with loved ones they don't normally get to see is often a fun break from the routine. Depends on the people in your family, though.
- Big theme parks or water parks with higher cost of admission (and often more involved travel logistics).
I'm probably missing a bunch. But that's what I can think of right now.
OP, how about you? You mentioned you've already got some things going on, maybe we can compare notes.