You wrote that I used to have Playmemories Home on my old Sony laptop (I never had a Sony camera though). It was a really basic program with some batch editing features, and you can also set an "open with Affinity Photo" button. Search function is quite basic (by labels, camera, lens, rating, date, etc.), it had a calendar view, possibility to add simple info (title, description) and labels, and it was completely free. I remember it as having a nice looking ui, but I didn't use it because it was too slow. Sony might have updated it since then, so it may worth a try.
PlayMemories Home Download (sony.co.jp)