I completely agree that the self-hosting story for Plausible is overkill for most websites.

So much so that I made my own that focuses on self-hostability using SQLite and DuckDB (no external dependencies, can run on a 256MB VM): https://github.com/medama-io/medama