This is completely missing from TNG, DS9, VOY and ENT.
Not completely. It took a while for TNG to settle into the "wallpaper music" the later series are known for. Dennis McCarthy had a Picard motif that he used frequently throughout the first three seasons (perhaps most memorably in the climax of "Yesterday's Enterprise"), and Ron Jones had recurring motifs for the Klingons (based on Goldsmith's Klingon motif) and the Romulans, plus a recurring Enterprise
motif that he introduced once he decided the show had established its own identity and needed to move beyond the Courage fanfare and the Goldsmith TMP theme.
Also, Jay Chattaway had a recurring motif for Species 8472 on VGR.