Get a mac mini! It’s dirt cheap for what you get. I switched from Windows home PC to mac mini specifically for home media library management. The built-in Photos app in Mac OS is absolutely incredible for photo/video organization. I have TBs of photos and videos accumulated over the years. They are stored on external HDDs (some used to be in Google Drive). With the Photos app you can import all your media w/o copying files to the tiny SSD of mac, it creates small reference files. The Photos app has indexed over 200,000 photo and video files that I have, organized by people names (faces), pet names, locations, dates, etc. It also created tons of auto memories which I is better than anything I could come up with. I don’t think Windows has anything even close to this level of organization and no software purchase needed.
Data Hoarder
We are digital librarians. Among us are represented the various reasons to keep data -- legal requirements, competitive requirements, uncertainty of permanence of cloud services, distaste for transmitting your data externally (e.g. government or corporate espionage), cultural and familial archivists, internet collapse preppers, and people who do it themselves so they're sure it's done right. Everyone has their reasons for curating the data they have decided to keep (either forever or For A Damn Long Time (tm) ). Along the way we have sought out like-minded individuals to exchange strategies, war stories, and cautionary tales of failures.
Thanks. I’ve been thinking of getting a mini. I’m a little confused though. When you say you have photos on external drives so they don’t take up space on the mini, are they always connected? Or do you mean they’re uploaded to iCloud?