For a big catalog I lean on automated collection rules (tags for material, use case, price tier) so it stays consistent as new products get added, then manually pin a few bestsellers at the top of each collection for merchandising. The other thing that matters is the mega menu...