As someone who's only played one game of Warhammer 40,000 in my life, but watched several dozen more from the sidelines, a bit of gorgeously modeled and painted terrain is just as compelling as a horde of tyranid or ork figures. One huge Warhammer fan has taken his love of the original Warhammer 40,000: Dawn of War real-time strategy game to the next level, taking terrain models from the game and 3D printing them for his own tabletop battles.
Jay from Eons of Battle shared details of how he built his Dawn of War terrain on YouTube. He started out by taking his two favorite building types from the videogame, the tall plasma generator and the wide stronghold, and making cardboard mockups to help establish scale. As an amateur voxel artist, I sympathize with how much trouble scale calculations are, to say nothing of having to adhere to Warhammer rules. Jay was forced to pretty much throw out most of his calculations since the videogame works on a different scale than the tabletop version, where height, width, and length can make or break plenty of terrain-focused strategies.
Using 3D modelings software like Vectorworks and Blender, and later a 3D printer, Jay was able to not just model the Dawn of War terrain, but also add plenty of artificial damage to each surface, further selling his idea that his fictional battlefield had seen generations of warfare between the Imperium of Man and the orks.
As you'd expect of professional Warhammer 40,000 painters, Jay committed roughly 25 hours towards painting and further detailing each piece of terrain. Dawn of War's plasma generators each got a healthy blue glow thanks to some interior spray paint, and even the exterior lights on the stronghold got a dash of putrid green spray to look like they're illuminated.
Best of all, Eons of Battle has made some of the models available for free, and others for Patreon subscribers. You can download the plasma generator model for free here, and all the other bits on their Patreon.