I have, at times, participated in games which feature "all of the above." I can't say I've had any inclination to discount one over the other. I will say, that despite the Cthulu-junior mind-flayers, I haven't found D&D to be a particularly good vehicle for "cosmic horror" and the like. However, I think that's more a conflict with the "heroic" nature of D&D's PCs.
With that possible exception, I feel its more about the presentation, rather than any particular subset of sci-fi. For instance; I've never been a big fan of D&D's psionics (any version of them), but there were 3rd party products with new "psionics" systems that I liked a lot more.