If you have a head following another head, then yes–you need to create a separate style sheet. InDesign will add the space below the one head and the space above the second head. In that case, you create a second style sheet for the second head and remove the space above.
And if you have a paragraph or bulleted list with space below it, followed by a head, then you either need to create a different style sheet for the bulleted list with no space below, or a different head style sheet with one less line space.
I’m not too familiar with Framemaker, as it’s been years since I had to use it for a few jobs. But I found it clunky and aggravating. But different style sheets was necessary back in the Quark days, and before that–in the Penta and Sun Miles system. It’s not something new.
I personally don’t find it daunting or sloppy because I’ve been used to it for 25+ years. I can see, however, how someone not used to it could find it that way though.
I don’t know if InDesign could change things so that those spaces were added together, but that may be opening up a whole new can of worms.