I'm using Photos managing my 50k+ RAWs library and its doable. I'm not living from photography but I consider myself serious enthusiasts. Photos has its limitations of course, but it really depends on your use case. Batch editing/processing is one of the missing features I hope apple will add in time.
There are two features Photos can be really useful for thread starter based on the initial post: "..Organizing into themes. (By Geo, by Family member in the picture, etc) Most of the time is probably spent here .." --> faces and memories
I personally love it - after initial faces processing (it took a while with 50k photos) I can select a person and create few minutes memory with smartly/automatically selected photos covering last 15 years - priceless.
Photos on its own creates memories - not all of them are relevant, but I find it fun to get last years anniversary memory when the date is coming.
There are two features Photos can be really useful for thread starter based on the initial post: "..Organizing into themes. (By Geo, by Family member in the picture, etc) Most of the time is probably spent here .." --> faces and memories
I personally love it - after initial faces processing (it took a while with 50k photos) I can select a person and create few minutes memory with smartly/automatically selected photos covering last 15 years - priceless.
Photos on its own creates memories - not all of them are relevant, but I find it fun to get last years anniversary memory when the date is coming.