I'm pro nuclear power, but I couldn't resist the pop culture reference. And it's good to remember what can go wrong when people's fallibility interacts with a powerful technology.
(Dialog from a memorable Call of Duty level based on Pripyat, Ukraine, near Chernobyl)
Many old school plants also rely on dams and provide massive ponds. Which sucks during construction when some people have to move. But in my experience after several decades people are pretty happy to live next to those massive ponds. If I'd have to pick living next to a massive lake which allows boats/yachts/etc (which is not so common in my whereabouts) with a plant on the other side of that lake vs. lake-sized solar plant... Former does sound better.