In the backend the view creator can add fields as options for sorting from the dropdown on the front end. On the front end, there would be a dropdown with the label Sort where the user can choose one of the options in the front end. This would be especially helpful with List View, Layout Builder, or DIY view.

For example, a front-end viewer may see a view sorted by creation date, but may want to see the view sorted by creator. The current "Sort by field" and "Sort by secondary field" settings would be the default and would then become secondary and third sort after a field is selected by a front-end user.