Weekly Digest Email to Group (Mailing List)
As a partial answer, we did some work to enable a View to be pulled in to a civimail as a token. The code is here but could do with some further improvements and is untested afaik in respect of Scheduled Reminders.