Science Fantasy is perhaps one of the most pervasive genres in existence. The most powerful example in Western culture would be Star Wars, which is often considered the penultimate science-fantasy by fanboys. However, the genre also gained some minor popularity elsewhere, with the Deathstalker Saga and a few others prior to the current fantasy/sci-fi publishing boom that hit after ebooks took off. The Superhero genre can also be considered to be science-fantasy in a general sense, making it a bigger umbrella than most think.
JRPGs such as the old Breath of Fire series and Xenogears both included elements of science-fantasy, mixing magic and tech freely, and this was also seen in Final Fantasy VI, where magitech was at the center of the story for much of the game. For VNs, my beloved Silverio series is worth mentioning, as the series has a basis in science-fantasy rather than being pure fantasy.
Perhaps the most notable aspect of science-fantasy is that it combines the flexibility of fantasy with an internal consistency reminiscent of science-fiction in many cases. Fantasy is an infinitely flexible genre with no real limits, whereas science-fiction is usually an extension of our world, seen as a potential future or past. When the two are combined, you get a genre that seems partially like an extension of the world we know and partially a realm of pure fantasy and imagination.