Why do you think I didn't like Star Trek 2009 and why do you think I'm a fan of Stargate?
I liked Star Trek 2009 a lot, it has good action, good characters, interesting dynamics... . Science Fantasy is not a term I use to make a movie sound bad. I love the old Star Wars movies. They have believable characters and much more.
The way you just now used the term sci-fi now encompasses all sub genres and mixes and what not which is fine. I'm not saying "good" sci-fi needs to be like this or that.
I'm not a fan of the nonsense tech-talk on TNG, in fact I dislike it a lot. If a movie creator doesn't take his time to come up with something sensible and useful plotwise then I'd advice him to not bring up the tech-talk at all.