Depending on just how narrow you want the question to be, there could be a lot.
I'm going to assume X-Men stuff doesn't count as that's a world filled with superheroes and mutants, and not quite our modern world. Same with Dragon Ball Z? Also assume simply another world to ours doesn't count? Dragon Ball Z, Alien Nation, District 9, Spiderman, Transformers, many more.
Echo first comment, Bill and Ted's Excellent Adventure, scoop some famous people up, and plop them in the (then) modern world and watch them interact with a mall.
Think there's two Korean dramas on Netflix with that plot. I think one's called Rooftop Prince? About a guy from some dynasty popping up in the modern day.
guess I'll echo the Dark Tower (book) series.
A number of monster/slasher movies have the basic idea in them. Some shits get together chant some spell and a door in time and space opens somewhere and out comes our monster for the movie.
Terminator movies, again how narrow you want to go, however, time travel from a constantly changing "future" the date for Judgement Day changes, the day they take over changes, it's not set.
Quantum Leap TV show where a scientist in thee future gets buggled up in an experiment and gets trapped jumping from body to body and from time to time in our modern day past.
See also Star Trek where on occasion either through time travel or holo deck the crew(s) take a little spin around our modern day Earth, or at least close enough to modern time.
Also mentioned previously the tv show Supernatural, where in one episode Sam and Dean Winchester, demon hunters, are popped into our world where they inhabit the bodies of Jensen and Jared, the actors whole play them on TV.
Also Buffy the Vampire Slayer ? Where Buffy Summers Vampire Slayer finds herself in a mental hospital in the "real world"?
Previously mentioned movies of Enchanted as well as Kate and Leopold.
Tempted to add Alan Wake (video game) as a dark presence entering a modern world.
Dino Crisis ? In which in our modern world a new energy source is being worked on and rips open a portal and out come Dinosaurs.
the Time Traveler's Wife I don't think fits the criteria, but now mentioned.
Then there's those in which are in a fantasy world and another fantasy world teleport into theirs, WarCraft with the arrival of the Orcs. X-Men, Bishop, Azazel, more. Dragon Ball Z Trunks and Cell <- Terminator logic.
Then the opposite. Modern world, or a fantasy world where characters then teleport to (other) fantasy worlds, see Tsubasa Chronicles and the TV show Sliders. As well as many many more.