Damn this is neat I didn't realize I wanted this until now thank you!

I use a datetree format for my dailies so I managed to make this work via a few modifications to +org-roam-updated-on-save. Maybe this will come in handy for someone else

With my current daily capture templates as:

(setq org-roam-dailies-capture-templates
'(("d" "default" entry "* %?" :target (file+datetree "dailies.org" week))))

some tiny changes to the key for org-roam-dailies-goto-today, the link text, and making it go to end of subtree before inserting the link

(defun +org-roam-updated-on-save ()
    ...
    (link-text (format "[[id:%s][%s]]\n" id title)))
    ...
    (org-roam-dailies-goto-today "d")
    ...
    (if (not (eq 'plain-list (org-element-type elt)))
      (progn
        (org-end-of-subtree)          
        (insert "\n- " link-text))

Edit: this might not fully work with regards to not putting the same node over and over