Good resource for photo storage options?
Can someone point me to a reliable resource on options / setup for an effective home photos storage solution?
My wife and I both have Mac Book Pros whose hard drives have been maxed out by our Photos libraries. I've read countless articles/posts on using external drives, not using NAS as a solution for photos, using Airport (and not using Airport), etc., but I feel like I'm running in circles without a clear idea of what would be the best way to go. What one person recommends another claims will be a disaster.
Ideally, her photos and my photos would be separate and stored on some kind of external easily accessible media (to free the Mac hard drive). I'd be fine with combining the libraries into one pool of photos accessible by all if that is a more workable solution. We'll also be adding a desktop (mac) that we would like to access one or both libraries as well. Of course, I also want to implement some kind of mirror storage in case the main drive gets wiped out (and consider some kind of additional off-site storage as a second backup) so the photos are safe. I'm trying to avoid cloud storage due to cost (we have LOTS of pics), but I'm not 100% against the idea if that's the best option. But I do want something that's fairly easy to use and doesn't require unplugging and plugging in various external drives to access the photo library. (Also, with the external drive solution, I'm unclear where iphone photos you take on a daily basis (that sync to the Mac) would be stored, and whether they'd have to be manually moved from the Mac to the external drive every few weeks. I'm looking for something as automated as possible.)
Thanks in advance for any responses. If you have your own detailed setup you'd like to share, obviously I'd really appreciate that. But I'm fine just being pointed to a good resource that's already out there that someone feels would be a good solution for Photos. I think the info I need is probably out there -- I just haven't found it yet.
MacBook Pro with Retina display, iOS 10.2.1