The fracking fluid get's pumped into the well to fracture the earth about 10,000 feet down. Then the fluid and the oil/gas come back up in the well. The fluid never leaves the well or gas deposit. When it comes back up it's stored and reused at the next drill sight.
Most of the nasty chemicals in the fracking fluid are actually picked up from the earth it's being pushed through. But still, you have to be responsible for that when it comes back up. Any of the fluid that doesn't come up, is still left behind inside the oil well. So if the oil well wasn't already leaking up 9,000 feet to our water wells, neither will the fracking fluid.
No different than oil really. As long as you don't spill anything, it's pretty fair. The huge push against it, is mostly political, and has nothing to do with the environment at all. Green is just a tool.
The only problem I've currently witness is with oil fracking. Shale oil is only worthwhile to produce when the price of gasoline is over $4.00. Thanks to the Saudi's desperate attempt to artificially lower the price of fuel to put fracking out of biz, we have a bunch of wells that are shut down. So that means that the fracking fluid has to be stored or cleaned. Because it's usually recycled to the next well. If we aren't drilling more wells, then we have excess fluid. So fluid storage and cleaning/disposal is becoming a very quick growing industry right now.
Solar is the best residential option. I have about a dozen customers that are 100% solar. (except for heat in the winter) They still have utility electric connected, and the solar system power module can seamlessly transfer load to utility if the batteries get low. Resi natural gas generators are a poor option. Good for standby only, and they stink at that, even.
I'm amazed that solar hasn't become more popular. The price is coming down. It's hardly more expensive than a standby generator. If we could get 50% of our residential load from solar and not the grid, the positive environmental effect would be huge. Keep in mind that most of the power output of a power plant, is lost traveling through the grid.