Score can play many roles in movies. It can create tone and style, it can support subtext in scenes, frame characters and their secrets, create thematic unity between separate storylines, create tempo or propulsion or pathos or even a loose comedic feeling and it can facilitate transitions. But you are right that some film makers have grand collaborations with composers where the direction and music work in glorious unison. And sometimes the musical aspects on a film can seem perfunctory. This might be a failure of the film maker or the composer to get in "harmony", or it might be that a score is not of interest to a particular film maker on a particular film. But some of us attempt to get to that glorious place you are talking about where the images and the music are a unique and braided experience. This requires time and commitment, courage, generosity and craftsmanship between the principals. It also requires the film maker to create spaces in their film where the composer can assert themselves without too much talking and sound effects and rapid cuts. In most of the greatest director/composer collaborations you will see that the film maker gave the composer some moments they could take center stage instead of fighting their way through.
www.youtube.com/watch?v=_pV6zRGeeGM