I recently got access to a lot of family photos from late 90's, early 00's, and I want to scan and organize them. Scanning is fine, but I want a tool or something that allows me to quickly add metadata (date, place) to them since they are analog photos with the date in the bottom corner. Until I don't find something better, Google Photos automatically creates albums, timelines and such after I do that.
What software do you recommend for adding metadata and/or an offline alternative to google photos? with the same abilty of automatically sorting them. This is a new datahoarding venture for me but I'm excited.

pic unrelated but I made it