Nuclear is still likely cost effective at night, or in the rainy season. The only other carbon neutral technologies rely on special geographical features (geothermal, hydro).
One way to think about energy moving forward is reducing the problem to heating houses with heat pumps during stormy weather, or at night.
Solar, wind and batteries basically imply we'll have surplus energy in all other scenarios.