Combing through spec history

My friend recently asked me if I could "revive" her dusty old desktops with some tech magic, and so I started thinking about installing Linux on them. While thinking about that, I realized that a general specs-to-distro/DE guide would be handy for projects like this. However, I'm fairly recent to the whole tech enthusiast thing and I was hoping people on the forum here could provide a brief timeline or history of the progression of consumer desktop specs (in regards to CPU clock, RAM, storage, etc.) over the past 10-15 years or so. Any help would be appreciated, thanks! :)