They’re pretty rare, I’ve only seen them one time, and my grandma in northern Ontario only ever saw them once in her 80+ years.
It was such an event in her town that everyone went out to the street to see. When I saw them I also went into the street to take it in, but I didn’t see anyone else enjoying it
Apparently they’re more common in the US plain states (not sure what they include)