Cindy & I have been on a well for nearly 30 years. The water's fine. The caveat is that water can vary from well to well. I suggest you ask neighbors of a property you're thinking of buying. Before we bought this place, I was concerned about the well being too shallow. I asked a high school classmate, a neighboring farmer whose family homesteaded the area. He replied that the well would never run dry, the water would be clean & sweet, and that if I drilled deeper the water would be worse.
He was right. Neighbors to the East of me had a well drilled deeper. Now they buy bottled water.
Local knowledge is king when talking wells and septic systems. With septic systems, the soil type is a big factor, also the design itself.
Power outages can be problematic, but we usually have some "survival" water stored. During storms that may knock out power we fill lots of buckets for toilet flushing if the power goes. Outages here haven't lasted longer than a few days...if your water pressure tank has a bladder system and the lines have check valves, a submersible pump in the well, no problems with restarting when power is restored. Another modification I did to the system was install ball valves instead of gate valves on the shut-off points. Especially in rural areas, it's good to have flashlights, oil lamps, and a good battery powered radio ready for use. For heat? We have a woodstove and a cord or two of wood in the shed. Even without a generator, we survive okay when the power goes.