Severe thunderstorms have marked a spectacular end to scorching days and nights, as the recent heatwave affecting much of South East Queensland came to an abrupt end.