Who expected real science in a film called "The Core"... that featured an inverse rocketship that travels to --surprise-- the Earth's core?
That's pretty close to expecting a laugh track in "Schindler's List". Or perhaps a cameo by Hello Kitty in "The Sorrow and the Pity" (see, then the tag-line could have been "The Sorrow and the Kitty!". Genius, I say...)
I have a hard time thinking of a movie that qualifies. All the SF films I can think of fit into the category "comic book/pulp science".
Maybe "Event Horizon", which looked almost 2001/2010-ish for the 1st 45 minutes or so, until it morphed into a totally unimaginative horror flick (now if it would have morphed into a smart horror flick, it would have rocked).
And Sphere. Not even my new HDTV could make that anything but crap, though I was astounded by how clear the text on all the little, meaningless computer displays were in HD...