Hey Lab,
I live in Arvada (I'm overseas right now), which is about 10-15 minutes from Golden, I can tell you that Colorado real estate has gotten really expensive in the last 10 years (don't know compared to Ohio), shooting clubs are all over, theres one right there in Golden, lots of places to shoot around the foothills and mountains, indoor ranges are located here and there, not too hard to find one close.
School systems are good to go, stay out of the Denver school system itself. Know idea about boy scouts but there is LOTS for the kids to do as far as activities, you'll have no trouble at all finding whatever you want, soccer, karate, dancing, that kind of thing. We have Water World, Six Flags, Ocean Journey, skiing (of course), and a pretty good nightlife. Good restaurants everywhere.
I would start by looking at living in Golden itself, if you need to get a little further away, go Westminster, Thornton or Arvada, all pretty good neighborhoods. Again, don't live in Denver itself.
Good luck, brother, welcome aboard.
Don