Camping is a wonderful activity for the whole family.
The "horror stories" that you mention are blown way out of proportion because they get so much news coverage, but they are actually quite rare (no one reports the safe, uneventful camping trips). Safe camping requires that you do some homework. Know the natural hazards (waterfalls, caves, natural predators (bears, etc.) and know poison plants.