I never had problems with that, and can remember what most things did. The techs were colour coded and clearly listed what they did. "String Theory" wasn't a tech, it was Superstring Theory and it gave you the Chaos Gun. Since it said Chaos "Gun" it was pretty clear what it did. The game told you that a better reactor gave more hit points and reduced the cost of excessively powerful unit mods (it even gave a warning in the design screen when the costs got excessive.) Children's Creche is obviously a growth modifier (also gave defender morale and base efficiency). All the Secrets techs gave you a free tech from being the first to get it, I'm pretty sure there was a message when it happened that made it clear about that too.
SMAC had a complicated tech tree, but it was in no way cryptic.
It's "cryptic" compared to Civ. C'mon--it's pretty obvious what a library, granary, or wall does; it's significantly less obvious what a network node, children's creche, or tree farm does. Yeah, if you like being pulled into the theme via all those trope shifts, it can be fun. But it's still a bit confusing until you get used to it. I'd be having a terrible time with AoW3 right now if it wasn't for all the pop-up info. I'm constantly asking myself, "What in the world does X do?" But thanks to the modern interface, I get an instant answer just by hovering the pointer over X and reading about it. I can do something like that in Endless Space too, but I gave up; I didn't want to bother learning all the stupid names for various tech advances. Same in Sword of the Stars, except that the 3D tech tree was what made me give up there.
Of course, it's not always obvious in Civ either. I used to know what the Pyramids did--provided extra workers and made work faster. The idea was that if you can build the pyramids, you'll be good at building other things. In later versions of the game, the Pyramids wonder allows you to change governments instead. Huh? Where's the connection there?
My point is, every "trope" ought to serve as a good mnemonic device. Its name and description ought to match up with what it does in the game.
As I've said, it's not a big problem. Just a little annoyance for me. But it's just me, I guess. My attitude is that flavor text is nothing but icing on the cake. I could do without it altogether; if it's there, I want it to stay out of the way of my game play.
Because of that, I'm one of those wondering if Planetfall will turn out to be just a reskinned AoW with less melee and more ranged weapons. If so, it'll be a take-it-or-leave it thing for me. I really don't care of the theme is history, fantasy, or sci-fi. The main thing is, how does the game play?