Is National Honor Society really that important for top colleges?

No doubt, and you keep missing the point. NHS will not make you stand out, that seems to be your point.