I’ve only ever seen one geothermal unit installed here in NC. In this case the property had a lake and the pipes were run along its bottom to pre-cool the water before using in the AC and pre-heat for the heat pump in the winter.
We’ve evaluated the pros and cons of using geothermal in lieu of cooling towers in larger buildings, but it never seems to pan out when you compare the first cost vs. the long term costs of operating. Has a lot to do with your planning horizon.
I could see it making economic sense if you were planning on keeping the same house for the duration of a 30 year mortgage. But I’ll admit to not being fully up to date on the costs for a single house scale installation.
My neighbor here in Indiana has a closed loop ground heat pump (advertised as WaterFurnace). Low utility (electric) costs but has a fair amount of maintenance and repairs compared to what I would consider “normal” for the typical electric A/C and gas furnace.