I'm not sure you understand the issue - the problem is not sharing FROM Photos. It is selecting a photo from WITHIN a social media app.
In particular, if you draft a Twitter response (and share is not an option) then select the insert media icon, you are taken to what looks like Finder/Pictures but with limited control other the View than Insert or Cancel. You cannot change the size of the thumbnails which are too small to identify in a file of thousands.
I know how to change the size of thumbnails in Finder/Pictures - but it doesn't work when coming in from another app. As I said previously, it seems to be some sort of Preview view. I also know that I can enlarge thumbnails by selection, but that doesn't help when you're scanning thousands of thumbnails.
What seems to be required is that (1) the default setting needs to change to take you to Photos - and not the Finder/Pictures Preview - but I doubt that's possible, or (2) more control over thumbnail size needs to be given over the Preview view when accessed from an app like Twitter.