In short, we don't do stuff like that in the US (at least, not much) because it's often a good way to lose money.
Also, I don't know about Spain, but large parts of the US suffer very high humidity through much of the year. Unless you're on an exposed hilltop with a breeze, it's miserable without good air conditioning. Houses aren't build with cooling-via-open-window in mind anymore, either, having fewer and smaller windows than older houses and being built with no thought to positioning the windows and the house itself such that prevailing winds can blow through it. Many interior materials aren't intended to tolerate even moderate temperature and/or humidity swings anymore, and will deteriorate much more quickly under those conditions. So there aren't many days in a year when it's possible to get by with no heating or cooling and just open your windows, either.
Lol, Geothermal costs more than the electricity prices. Geothermal costs $25,000ish. It'd be cheaper to install the Powerwall!
In my state, a kWhr costs $0.08. Large air conditioning units are more efficient. I have a programmable thermostat that keeps the air conditioner off the vast majority of the time.
-----------
The name of the game is to buy big, efficient units. They draw a lot of power while they're on but then they shutoff once your house reaches 76 degrees (or ~24.5 Celsius).
Again, you buy big to be more efficient. We've run the math already. A big efficient whole-house 3-ton AC unit for $1500 is much much cheaper than a Geothermal unit of $25,000.
Then get a programmable thermostat to keep it on only when you need it.
Wow, it always surprises me how much Americans waste and consider it totally normal(I bet you are American, in the rest of the world it would be difficult to emit that expression with a straight face).
Have you considered alternatives? My house in sunny Spain spends less than 1Kwatt in August pumping water in a pipeline in the soil that has a big thermal inertia, and small air conditioning units for the air.
You don't need more if you have good insulation.