If you want to spend some time looking at critiques from someone with experience, I find JANG's Youtube reviews of both LEGO and non-LEGO brick toys to be well-balanced. We have differing opinions, but he has decent rationales for most of his opinions.
Minifigs are terrible but I have hundreds of those spare anyway!
I grew up with the mid 80s to mid 90s kits, mostly castles and pirate ships, a few space sets. I think it's a very different experience compared to the nightmares I read about building the Mould King Eclipse-class Star Destroyer ( https://www.reddit.com/r/lepin/comments/1pdfx5y/mould_king_e... ). The concept of "bad luck with construction" is foreign to me, because most of the kits I remember building as a child were comparatively simple.
I'm working on this house with my 5yo daughter now: ( https://ja.aliexpress.com/item/1005006068361257.html ). Costs ~$20, we work on it about 30-45 minutes several times a week, so it takes months to finish. If she tears it apart 6 months from now to build something from her imagination, mission accomplished.
I hear people rave about this Cyberpunk-style kit, maybe this is closer to what you expect? https://mp.weixin.qq.com/s/_a_a4b2bvISsP6pyjkSxLw (Chinese language review) I plan to buy it at some point....for myself, not for my kids!
Many of them are a really bad and expensive purchase if you only care about the theme itself, like the latest Death Star (or almost any Lego Star Wars set). You can usually buy a similar and cheaper non-lego model. Or the Titanic set too.
For what I spent buying JUST ( https://www.brickeconomy.com/set/60229-1/lego-city-space-roc... ) last year for my daughter,
I've since bought her a 3-floor hospital, a firehouse, a pink villa with pool, and about 2 dozen doctor and engineer minifigs for the same ~$120 outlay. Only disappointment is the legs on the Chinese minifigs, they are difficult to seat properly on studs because the legs are at a slight angle (almost like manspreading).
I have to stop myself from going on a spending spree on AliExpress, I might order an entire Age of Sail LEGO navy.