I could not find any decent tricks, but there is a possible way to use the Permalink normalizations
setting.
You could do, for example:
/security\/advisories\/[aA][dD][vV]-(\d+-\d+)/s-adv-\1
It transforms
security/advisories/ADV-2024-003
security/advisories/adv-2024-003
security/advisories/aDv-2024-003
…
→ s-adv-2024-003
Then, you create a redirect with it:
Would it work for you?