Comparison of geothermal heat pump with LWW pump

Air-water heat pump is active cooling (without compressor)
Brine-water heat pump is passive cooling (with compressor)

I can only share my experience with the brine-water heat pump and trench collector after a summer of passive cooling. However, I have never dealt with an air heat pump.
I set the brine pump to 5% power, which is completely sufficient. Monthly electricity consumption is negligible, I estimate it at a maximum of 5 EUR. With the actual room temperature, we could not notice big changes, but the perceived temperature was significantly higher due to cooling from below. Very pleasant with parquet flooring, almost too much with tiles. The cooling capacity decreased as the summer progressed, by the end of August it was no longer very noticeable.
With active cooling, the compressor is involved, which causes much higher wear and tear.

I would always choose to include it again.

Air-water heat pump is active cooling (without compressor)
Brine-water heat pump is passive cooling (with compressor)

exactly the other way round :p

Our brine-water heat pump only went into operation in October, so I can't share any personal experience yet. From what you read around, 3-4K cooling seems to be realistic.

exactly the other way around :p

I just thought to myself, something doesn't add up. It is clear that the cooling performance decreases over the summer. In winter, heat is extracted for heating, so the ground is nicely cool during the first heatwave in June. For cooling, heat is added again. For that, you should be able to heat quite efficiently in the first half of winter ;)