An important role we need to enable, for compliance reasons, is to restrict “Authors” to not be able to upload media, but be able to access the media library to choose from media that is uploaded by the super admin.
Unfortunately, WordPress checks hard-coded ‘upload_files’ permission in order to show/hide “Add Media’ button at the post editor, the same ‘upload_files’ is checked in order to show “Upload Files” tab at the next opened “Add Media” page or give access to “Media Library->Add New” menu item.
So I don’t see a way currently how to solve this task.