I’m happy to say that the new functionality to sort by multiple criteria flagged here has now been rolled out to my laptop and for me at least, it now does exactly what I want. I can now set up My Tasks to first sort by Due Date, and then sort by Priority, so for each day I have a prioritised list of tasks- success!
Surprised that no one else is mentioning this here, as I think we can consider the case closed?