FWIW things have dramatically improved in recent years. For example, latest Pixels claim to have 7 years of support [1].

I wonder how it will work in practice though, as often the quality of QA for system updates for old phones drops over time, and major bugs and perf regressions are being shipped.

[1] https://endoflife.date/pixel