I keep coming back to static site generators when a project is small and the content does not change every minute. A static generator builds plain HTML files ahead of time, so the server just hands them out. There is no database query per page view and no server-side template render at request time.
That approach trades flexibility for speed and simplicity. A blog with a few dozen posts rebuilds in seconds, and the result can sit on almost any static host. For a small team, that is often enough.