For me, the best is stories where the sci-fi or fantasy setting is a way to explore what society might be like if important aspects of present reality were different. Consistent worldbuilding is also a plus. Neal Stephenson does both in his best work. Likewise, Frank Herbert.
That said, I'm not opposed to ridiculous space opera or trashy urban fantasy. ;)