I believe my current Fedora install started as a Fedora 26 so rougly 10 years without issues on 2 different laptops with same install?
On servers I have changed providers so it never lasted as long but at work we upgraded ubuntu LTS at least twice on same hardware.
Before Fedora I had similar experience with slackware, freebsd, openbsd and ubuntu on my daily drivers.
The only upgrade that ever broke a system of mine was my own fault by not reading news on archlinux website and upgrading blindly right when they were doing the changes with /bin /usr/bin. But Arch is different, it is opinionated and not expected to be free of human homework.