Eventually, it came down to a choice between Plausible and Fathom. They both have a similar feature set, a good user interface to view my stats, and lightweight tracking scripts. I decided to go with Plausible in the end.
It mostly came down to pricing (Plausible starts at $12/month for ~100k views with a 33% discount if billed annually), and the fact that the codebase is fully open source and supports self-hosting without restrictions. On the other hand, Fathom starts at $14/month for the same amount of views and the V2 of the service is no longer open source. They have a Lite version on GitHub, but it’s clear from the Readme file that they don’t want anyone to use it."