York and North Yorkshire experienced a 'spectacular' storm for several hours on Sunday night.