Feng shui must be good if you live by the water

Not necessarily, some are very bad! Some are good and some are average. But in comparison, in large areas, places with a lot of water are relatively better. It's just relative, not absolute. Being by the water is good. It depends on the specific details. As long as the water is used properly, it will be harmful if it is used incorrectly.