Any sufficiently advanced technology is indistinguishable from magic. Carke's third law of Clarke's three laws.
I think the real world is less interesting because we've pretty much got it all figured out
tell that a physicist, a biologist, an astronomer or a medical scientist and they will laugh at you. for sure.
The only things we have left to discover are only really relevant to extreme experts in their fields and have little to do with every-day life
once again wrong. think if physics. most of our knowledge is still pure theory, while of course some of them has a high chance of beeing correct, or near correct. and it has pretty much to do with the every-day life. there are many, many examples of it. think of all that luxury were enjoying today. i prefer living more than 50 years. not 300 years ago getting older happed rarely.
we just dont realize, because the human brain tends to simply ignore things we dont understand (otherwise pretty much of society and politics would just not work

... especially religion! ouch! hot topic! )
which takes us to the second detail: you need to train your brain to start questioning. which is work. much work. acquiring knowledge is work. which is another reason why not everybody is an explorer, inventor and so on, its not as easy as depicted in movies. real exploring often takes months, weeks of often boring, everyday-the-same research.
In fantasy worlds there's just so much more to discover- imagine how different society would have evolved if we had these unknown "magical" forces that could bend the fabric of space and time and create a whole new reality
for many people its 'easier' to be creative than logical or researching. (although easier shouldnt be mistaken as less worth here)
you wrote it yourself - imagine.
when, what you call 'discovering' is working its mostly your creative part of the brain that is working, filling all that stuff you hear with more stuff coming from yourself. thats how entertainment, especially fantasy and soft science-fiction works, books would be four times as long telling every detail, its the stories that fill your brain and vice-versa the brain that fills the stories.
when imaginating you can think of what you think is true or not true, whatever. while working on real stuff you cant just say 'oh it was that way? - na i prefer it that way. from now on the aztecs have invented flying space-crafts. because i prefer it that way!'
research is something that goes slow and hard.
Physics isn't in our control, it is the rules that are already in place, we just need to find out
you need to find out how the game works before you can play it. while much of the future will surely not work the way star trek etc. show it, someday we will be able to bend reality in a limited way as we are already doing it, maybe not that far away from some of the ideas of science-fiction.
who would have thought 10 years ago a computer would fit into a thin plate of metal not wider than a book?
that doesnt sound phenomal because were used to it. not 100 years ago much of the stuff were using today would have looked like pure magic to the people. which brings us to the citation i put on the start. but in some way - it alters reality. the reality we have been used to.
im sorry if anything i wrote isnt understandable, writing that many english at once im sometimes using wrong phrasing and that stuff.