Sites like Facebook or Reddit do indeed do a full reload, but most sites I frequent do not. Nice to be able to pick up where I left. If I want updated content I just hit F5.
I think it rather depends on the page (some pages with lots of dynamically generated content might mark themselves as no-cache/no-store), and in any case if you don't use a tab long enough, sooner or later it'll be evicted from the browser cache.