When an app asks for access to storage, whether it's all files access or just certain media types, I always just enable storage scopes for that app so it stops asking for access.
The only times I can think of where I add a file or folder to storage scopes for an app to access are:
- I need to send a file using a messenger app and the app doesn't support using the system file picker
- Editing specific photos (I either add the photo file or move the photo to a folder that's added in storage scopes)
- For gallery apps, I add regular media folders, like the Pictures, Movies, and DCIM folders.