My kit is mostly primes so 180mm is a very compelling focal length for a 1:1 or greater macro lens, imho.
The 65mm macro is a fine lens for head shots at 1:1 or higher magnifications, but for butterflies, dragonflies, grasshoppers and most other insects that are encountered in the field, a longer focal length is usually preferable.
Most of the participants on my wildlife photography tours use a 90mm or 100mm macro, and find that it offers a good working distance with nervous insects. A few use the Sigma 150mm macro or the 180mm Canon macro.
I’ve used a Canon 100mm F2.8L IS macro for years, and find it offers the best compromise, with a good working distance, light weight, and the important ability to be able to also shoot more distant subjects without having to swap lenses.
I’ve also got the Canon 180mm macro which has superior bokeh, but is more difficult to keep steady, despite the IBIS in my R5. I’ve also got a Sigma 150mm macro, but it’s heavy and slow focusing, so it’s purely there as a backup.
Back in the days of film, when we were generally limited to ISO 100 slide films, most people used flash to enable a usable combination of small aperture and freezing movement, but from my observations, the vast majority of people nowadays prefer to shoot by ambient lighting, unless they are working indoors or in the darkness of a rainforest interior.