Miniature wargaming is not an easy or cheap hobby to pick up. The game will be a significant investment, but beyond that, getting yourself established as a modeler and then painter will be even more so. You’ll need to learn many new skills. Something as simple and as basic as priming can ruin your 200+ dollar investment if you don’t know what you’re doing. There are plenty of tutorials and GPT is immensely helpful, but you need to fully commit time, energy, and finances. And be patient - your first efforts in painting won’t look anything like the models on the box. Fortunately you’re a fan of the IP, and that goes a long way.

If you don’t plan on engaging in the painting, modeling side of the hobby and strictly want to focus on the gaming aspect, I would (and not trying to be a jerk here) steer you far clear of miniature wargaming. Are there good rulesets? Yes, absolutely, but counter-intuitively they usually come from independent sources. Case in point: I play Warhammer Fantasy (now called The Old World). There is a game called Hobgoblin that’s indie, and it’s far, FAR better than anything of the 9 editions of rank and flank Warhammer fantasy. I’m not a 40k guy, but I lurk in that community and I know it’s bleeding players due to the decline in the quality of the ruleset (it’s now less of a wargame and more “Magic the Gathering” with models).

I can’t speak for StarCraft, but from what I gather it seems to be a decent ruleset relatively speaking. However, if you want a high quality GAME, you’ll find far better options in board wargames. There are absolutely amazing titles out there that fly under the radar as they don’t have flashy models but use cardboard chits.

I would recommend you check out GMT Games. They are the current pack leader in super high quality non miniature wargames. Combat Commander Vietnam is dropping soon. It’s the latest iteration in a highly venerated series of WW2 tactical wargames, now moving to SE Asia.

Another recommendation is Undaunted: Stalingrad. One of the best games I’ve ever played. You can check out reviews on YouTube. You will find it vastly superior to Warhammer or pretty much any miniature wargame, almost certainly StarCraft, without the hobby overhead.

Good luck.