Go for it! Doesn't even need that much investment as long as you're familiar with self-hosting. Just install it and see how it goes with new photos, and you can still backfill your old photos later. There is a tool that even lets you migrate your entire Google photos account, including albums, favorites etc super easily from Google takeout