Final Fantasy IX has the best video game music I've ever heard. Generally I like the music used in SE games, but if I had to pick a non-SE game, I'd say Lord of the Rings: Battle for Middle-Earth had some great music. Some of its themes are from the movies, but there's also a lot of new music, and it still feels like LotR music.