Wow, for the first time ever I had some technical automation I wanted to do and was able to solve it with Apple Shortcuts (open a daily note, create one if it doesn't exist).