I have them all. Some people buy these for the miniatures, some for the game. Some for both.
Silver Tower, Hammerhall and Cursed City have similar systems. CC is a newer, programmed campaign adventure while ST is random/procedural and HH is programmed, but HH and ST can share characters because they are the exact same system.
I’ve reduced the main critique of CC is that it’s samey and grindy. Maybe, but it’s pretty. And with some house rules from BGG, you can take it in new directions. One guy did an entire overhaul of the game. As others have said, you can get a copy sans minis for cheap and have lots of fun with Cursed City.
Blackstone Fortress is cool for it’s proto-40K vibe. There’s even some rules for playing solo as a space marine. You’re plundering a massive space ship the size of an entire world, looking for vaults filled with alien tech while everything, including the space ship, is trying to kill you. Again, you don’t need minis. But sometimes it’s fun to paint the minis and play through a game. It’s a complete hobby experience. This one is my favorite. And for all of these, it’s theme.
If you are playing for system, there are so many other choices. Though I’d say if you want the mechanical feel of a modern Advanced Warhammer Quest, go with League of Dungeoneers. Armor, hit locations, d100 system, quests, loot, dungeons out the was, full generative campaign system. miniature agnostic. But I digress…
You absolutely do not need minis for any of these games. A purist will tell you the game systems are fluff to sell plastic which is not without some truth. But the WHQ systems are fun and lite. Not every system needs to be a complex, brilliant mathematical expression.
If you like the Warhammer IP, I say go for it. You don’t need minis. BGG has lots of house rules to make Cursed City fun (the least expensive, and newest). I’d get a cheap copy, no minis, and houserule it. I hold a contention that people who advocate Silver Tower are biased from memory. I got in late, and judging all the titles, I feel like ST random generation and variety of enemies is the main draw. You can hack that into CC with houserules from BGG.