well I don't have one, I rarely ever drink wine at home, but there are dedicated devices for that, I think they are called wine cabinets in english? They could be used to store other things indeed. I have never looked at the energy consumption of these things.

I was thinking about more arcane solutions, like a basement in a stone house on the north face of the house.

Oh yes if you own the land that is the way but iy is not an option for me as I am in a 25y old appartment.