I used to think it was just a matter of product cost to do active cooling... really the problem isn't the temperature it's the dew point! Which I guess could probably be solved with enough hardware, planning, and cost as well... but a ridiculous amount compared to adding an electric heater for the opposite problem.

Come to think of it does anyone know of a consumer device that utilized active cooling (as in would get colder than ambient not just fans or whatnot)?

a fridge

I mean electronic device, things in a fridge/freezer generally don't mind condensation or deposition.

A pump, a home depot bucket in shade, some duct tape and tubing would probably be sufficient.

Thermoelectric coolers can cool below ambient. You can get them for CPUs, I saw one on a Linus YouTube video.

https://en.wikipedia.org/wiki/Thermoelectric_cooling

Sort of. Thermoelectric coolers transfer heat from a "cold side" to a "hot side", and generate a lot of additional heat in the process. They can be part of a cooling solution, but you still need active cooling (like a heat sink and fan) for the hot side -- they don't just "generate cold" in the kind of way that a resistive heater can generate heat.