Let me introduce you to your new favorite event, portrait, and indoor sports lens, the Canon RF 135mm F1.8 L IS USM Lens.
There are several reasons for this prediction.
The first is the focal length. The 135mm angle of view is narrow enough to encourage subject distances that create pleasing portrait perspectives, even for full-frame headshots. This angle of view also keeps the lens out of their personal space, staying distant enough for subjects to remain comfortable.
The ultra-wide aperture is another reason for this lens to be a favorite. The F1.8 aperture combined with high-performing image stabilization keeps shutter speeds up and ISO settings down for sharp, low-noise results. F1.8 combined with the medium telephoto focal length can create a strong background blur that makes the subject stand out from an otherwise distracting background.
If those two reasons are not sufficient for you, the image quality delivered by this lens will be. Even the preproduction lens produced outstanding image quality.
This mariachi band member performing at a low light event was a perfect subject for this lens and the Canon EOS R6 Mark II behind it.