I remember a friend of mine was trying to get me to implement this as a computer game. It came about around 2002-2006. Terrain pieces were stackable plastic hex pieces. Figures were similarly on hex pads, and had a series of stats. There were Ranged and melee attacks defined. Ranged attacks involved line of sight and measured distance from the tip of the weapon to a "vulnerable area" on the figure (shown in kind of a two color front and profile views on the associated chart). Characters had a mix of technology and magic (I remember one figure having a military rifle and a magic sword) and might have been drawn from different dimensions. There were some goblinoid characters also, I remember. And... that's most of what I remember at the moment, but it's bugging me.
I had a sudden inspiration and looked at an archived copy of a USB stick I carried back then and found the rules PDF. It was Heroscape.
Heroscape (stylized as "heroScape" or "HeroScape") is an expandable turn-based miniature wargaming system originally manufactured by Milton Bradley Company, and later by Wizards of the Coast, both subsidiaries of Hasbro, Inc., and discontinued by Hasbro in November 2010. The game is played using pre-painted miniature figures on a board made from interlocking hexagonal tiles that allow for construction of a large variety of 3D playing boards. The game is often noted and lauded by fans for the relatively high production quality of the game materials, in particular the pre-painted miniature figures as well as its interchangeable and variable landscape system.