Anyone know of a similarly excellent resource for understanding wired networking? CAT specifications, how to pick high quality switches/routers etc.?

Beej's guide will help you with understanding networking overall, I don't think it would help you choosing switches/routers specifically.