I worked on geothermal control systems a decade or so back. There are some less obvious applications for geothermal that reduce electric use (as opposed to generating electricity).
The systems I worked on were for cooling larger structures like commercial greenhouses, gov installations and mansions. 64° degree water would be pumped up from 400' down, run thru a series of chillers (for a/c) and then returned underground - about 20° or 25° warmer.
I always thought this method could be used to provide a/c for neighborhoods, operated as a neighborhood utility. I've not seen it done tho. I've seen neighborhood owned water supplies and sewer systems; it tells me the ownership part seems feasible.
Shallow geothermal works fine for heating. And you can use the ground as a heat sink. But if you want to generate power, you need to get down to where temperatures can boil water. That's deeper than most oil wells. Fervo Energy claims to have found 270C at 3350 meters well depth. That's progress.
I think you're describing what is known as "district energy" systems.
Whisper Valley in Austin Texas is one example of a neighborhood geothermal installation: https://www.canarymedia.com/articles/geothermal/texas-whispe...
Maybe not quite exactly what you envision.
Framingham, MA has a geothermal system using ground source heat pumps like what you are describing
https://www.smartcitiesdive.com/news/first-networked-geother...
District heating and chilled water is uneconomical for single-family homes. It does work well in medium to high density areas.
Isn't that similar to how neighborhood heat pumps work?
https://www.araner.com/blog/district-heating-in-sweden-effic...
One of the problems with the data center boom is its use of fresh water. How does geo-thermal plants use water and how much?
In the nordics it is common to have ground source heat pumps (brine in closed circuit pipe or bore hole) that are run backwards in summer to cool the house while actually assisting in storing heat back in the ground to extract in the winter. It’s a bit like regenerative breaking on electric cars.