Are there many tasks on a daily basis? Say 10 weekly tasks on Monday, 15 on Tuesday and so and is the overall number of repetitive tasks is very high in a week? Or are there only handful of daily tasks on each day that need to repeat every week?
Also is it okay if you have say a weekly task that needs to repeat for next 3 months ( so roughly 12 occurrences), then once defined for a week , it gets automatically added on a weekly basis instead of all 12 occcurences at a time? So for a task repeating on every Thursday, the next week ( 27th May task) gets automatically added on 20th May and one for 3rd June on 27th May?
If you are okay with the above and you have only a handful of tasks on daily basis, then I believe you can achieve it . One needs to use a good combination of actions, AppSheet automation feature and some added columns to define conditions for automatically adding the tasks for upcoming week or month.
I tested it on a small test app before responding to your query.