I do think geothermal has a part to play, specifically for heating and cooling of neighbourhoods and multifamily developments. The construction has to move a ton of dirt anyway, so might as well install some ground loops while you're at it. If you're forced to drill due to site conditions, the load is lower than pure electricity generation meaning the wells are not that deep. For private homes it's far too expensive to be much more than a curiosity, but amortized across a whole new neighbourhood or collection of apartment buildings it's very affordable. Especially in northern climates accessing the consistent ground heat source/sink that allows you to run heat pumps at max efficiency all year is a huge win and is a huge amount of electricity you never need to generate in the first place.