I know this doesn't answer your question, but hopefully it gives you another perspective.
My Lightroom folder is 218GB. My strategy is to keep "active" files on my MBPro and keep my master library on my NAS. I use Adobe Lightroom. I use VPN to get to my library when I'm remote, if needed.
This means that I'm working off the photos locally when I'm doing my editing and sorting, but once that's done I just put them on the NAS and access them over wifi (802.11ac).
On the downside, accessing files from the NAS is slower than accessing them locally. But it doesn't REALLY matter to me whether it takes 1/2 a second or 1.5 seconds to open an image. If I have a batch of photos I need to do some edits to I will move them to my local drive, edit them, then move them back.
I also cannot trivially access the photos while on the go. It's easy, but not trivial. I do have a VPN set up so at a pinch I can access my NAS photos from a coffee shop or even using the shared LTE connection on my iPhone. But it's not perfect. To date, that hasn't been a problem though. It's worked when I needed it to, and really it's not that often. The limitation is obviously the upstream bandwidth on my home Internet connection, which I think is 10Mb/s right now. It might be 20Mb/s, but it's nothing blazing fast.
So my local library is small, and it flies. I believe the SSD on the MacBook is as fast as the MBPro. I think on the newer MacBook it's actually even faster. The MacBook also has 802.11ac. It's shorter on horsepower but unless you're doing a large batch of edits that's probably immaterial. And if you're doing a large batch of edits then you can kick that off and grab a coffee of whatever. If performance is your number 1 priority the MacBook probably isn't for you anyway.
So my workflow is to take the photos, import them to the local library on my MBPro, then when I'm done editing and sorting I move them to the NAS. If I'm remote, I move them to the NAS when I am back at home. And if I'm remote and need to access the home library I do that over wifi/LTE as available.
The benefit is that my library is not bound by the storage limitations of my MacBook, so I bought a smaller 256GB model. I obviously also bought a NAS at some point. And upgraded my home network to 802.11ac at some point. The 512 is the smallest MacBook anyway, but if you have 200GB of photos now, that's virtually half your storage gone. I have 62GB of music too, which I know is small compared to some. But I keep that on the NAS too. Just those two libraries for me are 280GB, and yet I am able to work with a 256GB MBPro without limitation, and can continue to scale quickly and cheaply by just upgrading my NAS drives.
Again, I sacrifice speed when accessing stuff off the NAS over my local wifi. And on the road the impact is greater. But that's not a significant issue at all and in my regular workflow it's a non-issue.
I used to maintain an Aperture library and an iPhoto library. When I migrated to the MBPro from my old iMac I took that opportunity to migrate both Aperture and iPhoto photos to Lightroom. It was not fun, but I have no regrets. I have played with Photos a little but not enough to make a real world judgement call on it. So really, I can't answer your question very well, but hopefully it gives you some other ideas.