That's why the ground ones are dug vertically sometimes, they can get to stable temperatures.

However, a well may be "just poking" into that territory so you get the right temperature, but not enough surface area to do much heating/cooling.