As for the DLC itself, I really haven't enjoyed it and have made it the only Stellaris DLC I've downvoted on Steam. I tried to experience everything I could from it in two separate runs, and the bad far outweighs the good, primarily due to pathing. Pathing around storms needs to be removed immediately. Just like turn it off right now after you read this. And then the DLC would be a pretty but annoying and so ultimately a neutral piece of paid content for an otherwise great game.
If you want to make the whole storm thing worth engaging with you need to add a new minerals-only weather station megastructure - one per system. Planet build slots are too precious for buildings which are only used, what, 3% of the time by default? And the repulsion/attraction mechanics need to be much more interactive - when I spent a civic slot/origin on storm stuff I want to have near constant storms on my home systems and I want to be storm bombing my enemies. That has the potential to be fun, and players building weather stations, if only to limit storm damage, is preferable to inwardly groaning and just turning off the DLC before their next run, as at present.
Until the pathing issue is resolved I'll be running my next campaigns with it turned off. Mainly because of the pathing but also, I suspect, another bug where storms cause retreating fleets to disappear from the game completely.