I remember "Azrael's Tear" was quite good. FP action adventure for the Holy Grail.
Also "Extreme Assault" by Blue Byte (German developer, The Settlers). You were steering an attack helicopter which could transform into a tank in certain places

http://www.gog.com/wishlist/games etc

Thank you! Both titles were already suggested, and I voted for them.

Azrael's Tear: "The game features music written by Ray Shulman and Kerry Minnear, both former members of Gentle Giant."

Must vote for this one.