More levels & functionality needed in custom automations

There needs to be more levels and functionality in custom automations - ‘if’ functions, more ‘and’ levels, more column types supported, etc.

For example, I am trying to create an automation that works as follows:
~Every 1 week, if ‘status is X’ and ‘checkbox is Y’, then ‘notify Z’~
I can’t find any way of creating this automation, as there seems to be a limit on how many if/and functions you can include.

Also, checkbox columns aren’t supported in any type of automation - surely this renders them not that useful?