I'm genuinely curious as to what the key differences are (especially those that would cause someone to switch), as someone who is pretty tech savvy but whose use of Linux as a daily driver is admittedly pretty weak.

Folks capable of running linux pick the best distro for the job at hand. They are tools, there is no progression like you're implying.

My homeserver is Ubuntu, my gaming PC is Arch.