Too add to this, on my personal MBP I have the same home directory that I originally created in OS 10.2. I've used migration assistant, swapped/cloned drives, and in-place upgraded for the past 12 years. My work MBP is similar for the past 6 years.
I've had 2 or 3 issues where old config was the root cause, but those are few and far between. I might be an outlier, but it's always just "worked for me".
Edit: oops!
> created in OS 10.10.2
Of course, you meant OS 10.2 (a.k.a. Jaguar). Otherwise, it's not that impressive ;-)
It's potentially contradictory: the alternative is upgrading your OS and find pretty much everything where you left it, instead of having to reinstall everything. I.e. life is too short to spend time reinstalling everything.
Surely, it's an opportunity to do some cleanup of unused stuff, but otherwise, I haven't had a lot of problems upgrading OS X. (nothing memorable at least)