I have some experience with the SDS System. The biggest thing that characterises it and its close sibling, the AEC CADD standard, is that they both use FAR too many subcatagories for labels. Consequently, I use only a very small fraction...one doesn't normally need Mains and Laterals and Fittings and Fire lines and Abandoned Mains and Markers and Junctions - each with subacatagoies - all on different layers.
First, make sure you need all three you have cited.
It seems as if the labels are to serve any logical purpose, it is to exclude the other structures. Using that, I would label an underground stucture with valves and meters in them as "valve pit"; any with more than two penetrations as "junction box"; and any with change of direction only - without junctions, valves and meters - in them as "manhole". However, using that rational, I can't recall ever seeing a water "manhole", for the reasons given by cvg.
Remember, amateurs built the ark...professionals built the Titanic. -Steve