James Horner nailed the starship motif. I enjoy the various other composers’ works as well, but Horner is my top for Trek.

Howard Shore for all the Tolkien work. His music alone will paint the image of Middle Earth in my head.

And Hans Zimmer has some stuff I love, like Time, but he did his best job imo for Dune.