McOsu is a standalone osu! client, so its Workshop is almost entirely skins ported over from the main game. The popular ones are tournament and player-personal skins rather than anything exclusive to McOsu.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.