I'll not argue with anything in your post and accept the issues with CSP as per the status quo, but hot water needn't be a micro, single household scale. I've benefited from a CHP plant powered district heating system and it more than halved my energy use. There's definitely nothing wrong with big centralised heat generation and storage schemes. It also helps address baseload.