"Unheated" water in Austin, TX is blood-warm in July and August.

That's only true of environs so far south (and with very shallow water mains), though.  And if you were cooling by e.g. passively radiating heat to the sky at night, thermal mass would be the only way you could enjoy the benefits during the day.

Right, that's what I do.  use the fairly cool night to get my house down with an attic fan, then shut everything tight during the day, and use a little personal fan if needed.  Works great, and people think we have AC, which we never did.  But sure Alan.  In NO, that wouldn't work  As I remember, just hot and sticky ALL  the time.  So  I understood my thermo prof when he talked about heat death!  Been there.

But there are places in the US where the daily temp goes up and down like a yo-yo, and thermal mass can be used to great effect if you have the equivalent of a Maxwell demon working the in and out valves.  fortunately, yu can buy maxwell demons at radio shack these days.

The low this morning, just before dawn, was 81 F (27 C) with a dew point of 76 F (24 C).  This is slightly cooler than average for this time of the year.

Not much overnight cooling !