I currently have a daily automation which reads my reminders, and if it finds one matching a pattern (date is the next day and title starts with "Alarm: " then it marks the reminder as done and sets an alarm for the time the reminder was due.
I don't need that often, but I find it useful when deciding - a few days in advance - what time I need to get up to catch a flight or something.
I like my automation and felt smug that it worked, but it seems it may no longer be necessary 😁. I'm currently testing the new 26.2 option.