I think any cloud storage will let you share folders with people – Mega and Dropbox certainly do.
I’m sure Photos has its benefits, but there’s no way you could convince me to use a proprietary storage format again (I made that mistake with Lightroom back in the day). I’ve changed operating systems, editors and cloud providers multiple times since moving to a file-based approach and it has been essentially seamless. Even though I’m very happy with Apple (and Nitro!) at the moment, having to start from scratch if I ever change my mind is just too much hassle to consider.
Of course if you think you’re going to be in the Apple econsystem forever, maybe Photos makes sense. But even then I find it more frustrating to use than a logically ordered folder structure.