I'm not sure it was a "good" game per say, but I lost countless hours of my childhood to Unholy War. To my knowledge it was only released on the PS1. Pretty basic story line, tech advanced society needs special resource from magical type planet, and the campaign can be played out from either side. The maps are hexagonal, units have special abilities you can activate for a certain amount of the previously mentioned special resource that you harvest on map. When units fight it changes from a board game set up to something more akin to mortal combat. Each unit has special abilities and basic attacks. The fighting portion was pretty great, you can move in any direction, and several units had vertical moment abilities, there were map hazards to avoid.
It was just a lot of silly fun to me.