To have a good conversation someone must disagree a bit so that we'll continue to have a lively discussion. So let me play a kind practise-target to you guys.
I didn't find the midichlorian-thing making the Force in Star Wars uninteresting or dull. Quite the contrary. It became a kind of interesting idea, like qualitatively different atoms or something. And I wouldn't mind there being a scientifically satisfactory explanation to how the Palantirs work either (not that I am craving for such an explanation).
I think there is an issue of both misrepresenting science & underestimating it's creativity / overestimating our imagination.
Take the latter first. After the era of romanticism we have been in love with our "inner imagination" over the "dull reality". But it was already during the middle-ages that people realised what imagination is; it's a capability to rearrange things we have seen and to set normative & alternative views to the reality. Take a horn some animals have and put it on a horse and you get a unicorn. Look at a poor neighbourhood and imagine it rich (we know what being rich could be like) - just follow the cultural history of "afterlife" or "paradise" to see how it is tied to peoples' imagination that is dependent on the level of technology & culture of any given time and place.
God didn't give Moses and his people tanks and machine-guns - or send them buses or trains to get rid of the following Egyptians as that kind of technology had not yet been conceived of by men when the story was told and so people could not imagine them.
Confronted with odd experiences that had to do with light people used to imagine seeing angels (shiny people-like creatures with wings like birds have) and all kinds of similarly-built creatures. Nowadays we tend to see also Ufo's (technological devices looking more or less those things we now can build ourselves). One could continue this list...
So what we imagine is tied to what we have experienced. And mind you, most of the "new perspectives" that have really changed our way of looking at the world or which have actually changed our envirovenment come from science. The universality of abstractions, the theory of atoms or that of evolution, or dark matter or whatever you wish. Just mind-boggling ideas that easily make our mythologies look like unimaginative commonplaces - and just continuation of billiontimes used ideas.
So I'd say science is creative but our everyday imagination is less inventive.
Then the first point about misrepresenting science. I hear people saying oftentimes that science destroys the magic from the world. But does it really? (look above) Or they say that science only concerns itself with matter (which is normally thought of in a way of solid things like tables or flesh-built animals) and forgets the other things there must be.
But science is not tied to what we can see and feel. Science studies also energy, waves, quarks, laws of nature (can you see them?). In a sense theory of evolution or quantum-physics are more fantastic than any fantasy-novel will ever be. They make you draw breath and just look at them in awe. Comparing those ideas to some fantasy-character surviving death and coming back as a superhero look quite pale indeed.
And a cool thing about science is that it says openly that there are a lot of things we don't yet understand or know. Take human mind as an example. Science says that it's one of the most complex things in the whole universe. It has something to do with electricity-passing neurons and the chemical reactions in it can be tracked to certain extent. But frankly we have just taken the few preliminary steps into understanding a human mind. That I think is fascinating!
And if scientific studies suggest that we need to change our conceptions on what matter is, what is life, what being itself is, then science will change itself to make room for better views of reality (whatever that is...). The case of human mind is to the point. I'm eagerly looking forwards to the next breakthrough in science about mind which might actually challenge our everyday conceptions of matter and consciousness...
A new step there wouldn't spoil the miracle but would enhance it and raise it to a new level!
All that said, I do love and appreciate mythology and fantasy to the fullest. I just think science is not a threat to it but a well from where our imagination can replenish itself to become even more fantastic.