I hear you. The current heat wave up here has been killing me.
First thing first: There is nothing redneck about what you propose. It's what all the cool kids are doing. Massive downtown buildings on the Great Lakes are doing this to reduce their
energy footprint. New urban developments are doing this using drilled well systems. Even better: properly engineered, with heat pumps, it can work for cooling in summer and heating in winter.
Looking at potential "gotchas" in your play, three things come to mind: insulation, soil temperatures at depth, and wear-and-tear on electrical equipment.
Insulation comes first. Insulation almost always trumps complex heating/cooling solutions, both for cost and effectiveness. Do whatever you can to create passive systems that knock the problem down to size.
Soil temperatures are a big deal in the calculations. I vaguely recall that temperature maps are available for many areas. Basically, it will give you the data to determine what depth and radiative surface area is needed to add/subtract X number of BTUs/kJs. If you have a well, you can get some rough numbers by lowering a thermometer.
Direct drive from solar panels can work, but it's a tricky proposition because it's really hard on electric motors and can reduce their life quite a bit. The windings in motors overheat on voltage that is too high AND too low. If a PV panel is feeding a motor but the voltage is too low to start motion, the windings are effectively a toaster. The insulation on the windings will degrade. Pumps and fans are designed with the cooling flow of water or air in mind. So, heads-up.
Final thought: If you have access to large volumes of water, evaporative cooling is quick and simple. It might give the added kick needed to keep you comfortable while you work on the bigger picture. Cooling 200 sq. ft. is entirely do-able.
My 2c.