Skate Rift's workshop splits cleanly into maps and custom boards, and the board side is where the community's sense of humour lives. The map side has real highlights, including a couple of ports from much bigger skate games.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.