In short: you can't do better than water for heat storage at home.
Sticking with Wikipedia as a source, water's specific heat is 4.2 J/gK, but the heat of fusion for acetic acid (which, in pure form, melts around 62 F) is 192 J/g! So bringing pure acetic acid from 61F to 62F stores as much energy as bringing the same mass of water from 33F to 115F! (47C change). Shame about the flammability/causticity.
I agree water's probably the best by-the-numbers without phase change, but there are convenience issues and the phase change is so tempting. Assume a temperature range from 60F to 75F. That's 8.3C, so 35J/g vs. 192J/g for AA. DMSO is 184 J/g, so slightly over 5x the storage capacity of water.
Of course water costs me 4.2c/kgal, or 1.16x10^-6 c/g. DMSO is $12 for 4oz, or 10.6c/g. A factor of 5 in heat storage, a factor of 10 million in cost. I'm not even going to think about the acetic acid given the hazmat fees...where's those milk jugs again?
Thinking supply side: window is about 100"x40", or 2.6 square metres. Best-case around here is maybe 60 degree angle between the Sun and the window orientation, maybe 5 hours of good exposure so 1000W/m^2 * cos(45) * 2.6m^2 * 5 * 3600 = 33087600 J to store, or 260 gallons of water at 35J/g, weighing around a ton and costing two cents. The 55 gallon drum is going to be the expensive part.