In the US it basically comes down to, is the delay the airline's fault? If no (eg weather, ATC), then nothing. However, most US travel credit card comes with trip delay insurance which would cover the cost of an overnight stay, regardless of the reason of the delay.