Me too.
I have a double bind - I run on a 5-year old MacMini, still clinging to the last OS that runs iPhoto. For a year I've been experimenting with Photos and even Adobe Lightroom without success. I need to update the photo archive application and the underlying hardware.
I had a 30 day trial of Lightroom. It took 35 days just to convert my iPhoto library into what it used, and the convert failed at the end. I should have used smaller experiment set, but didn't have time to make it up.
I never edit photos, don't care about editing capabilities. On the other hand 'events' like iPhotos are essential for me to keep rolls of pictures together, for adjusting metadata, etc.
I have a working set of about 6 cameras thus need to keep photos grouped by camera. (Some cameras have the same model, so "smart albums" doesn't do the trick.) I archive cameras of several family members, so there are maybe closer to a few dozen different cameras in my set. I have scanned negatives going back 30-35 years too from old film cameras (and I keep the old notion of film rolls for them). In total I have over 150,000 images and movies, about 1TB of data. (That's probably not a lot to professional photographers.) I have this in 740 events - since 2011, I keep each camera divided by calendar year to prevent hitting any event limits (I don't want to find out if there are any).
I do have albums of events where I combine all cameras at an event into one. Time synching is an issue when this is done.
I change timezones frequently so I keep all the photos on UTC, synched to NTP. The problem cameras are on cell phones that swap time zones with me, the other cameras suffer clock drift. Without events, this becomes unwieldy (as each camera drifts differently).
Because my photos include film from the 1980, I have metadata comments describing the places and events. It took me about 5 years to collect all that - a lot of work. It's that work that I am afraid of losing.
I would just love a good photo archive package. Forget the editing.
The other bind - I mentioned 2 - is that I feel the need to replace hardware. My current MacMini has been running 5 years 24x7. The OS is old. I can't see any positive recommendations regarding Mac hardware - it seems everything is "old in the cycle." I am beginning to wonder if Apple is abandoning the Macintosh.
In that case - my search is for anything out there - open source OS or Windows. I realize the transition is going to be a lot of work no matter what, at this point.
Budget? Not worried - managing my photos has cost me a lot of time already, far more than any software costs I can imagine.