What do you use for automation? My first instinct is cron jobs running youtube-dl scripts against a set of playlist URLs, but I'd be interested to hear more.
Yep, you basically just described the setup, nothing super fancy :)
Cron job which runs a batch script at midnight which feeds youtube-dl some playlists URLS's which it downloads to a HDD. I also have nextcloud running which has access to the directory the videos are saved to, so I can easily share them if I want to.