well, just about every episode of 'the twilight zone' is a personal story, which is appropriate for the time allotted. for a fantasy novel, it's a lot harder to draw out a personal story over the course of a trilogy, particularly when some people's advice is 'if you can remove the fantasy from your story, do so,' i.e., if the fantasy is merely tacked on props and settings it should be taken away.
i always default to movies for examples because it's more likely something we're all more familiar with, so i give you 'practical magic.' it seems fantasy and romance are the two genres you can combine and come out with a personal story where the fate of the universe doesn't hinge on the outcome. in fact, isn't 'the illiad' rather a personal tale? 'a 1001 nights' is ostensibly a personal tale of scheherazod attempting to spare her life through storytelling, although the tales she tells are the fantasy... that's an odd-ball one depending on how you look at it, i guess.
i've also read several of those dungeons and dragons books, forgotten realms i believe they're called, where the world wasn't on the verge of disaster, although those tended to be more shorter stories woven together to form a larger tale.
of course, greek myths tend to be personal stories, too, but more morality tales. and if you think fables are fantasy, talking animals and the like, well, pick a disney movie. 'animal farm' springs to mind as a serious story, but you've got 'charlotte's web' and just too many to speak of.
dunno, does lemony snickett's count? pry not.
sci-fi-wise, choose an episode of star trek. quite a few are personal stories. i can only imagine how many star trek novels don't involve the ships destruction, tough probably most might have some kind of cheesy doomsday device in there somewhere, lol. but, you know, they only wrote about sixty-three thousand star trek novels, so odds are there has to be *some*, right? (note that they wrote a lot of star wars novels, too, but i can't think of a single one i ever read what didn't feature some galactic overtones.)
suffice it to say there are quite a few fantasy and sci-fi stories out there that aren't on a grand scale. maybe not as many, but they're out there... somewhere. not saying it's a balance of any kind, though. but, as mentioned, if you overlay a sub-genre like romance as a major element and not just as a sub-plot, that can seriously reduce your need for grand scale stories, eh? (i'd like to see some fantasy with a mystery template, something like a gandolf and sherlock holmes mixed character. that would require thought, though, and sadly most thought involved in fantasy comes through in how to put a twist on the standard kill the bad guy ending where the second act is so much fighting crazy monsters. you guys wanna change what's on the bookshelves? find ten good writers with good ideas and ten grand each to invest and start your own publishing company, then get a guy who'll run the whole thing on commission. make sure he runs it well on pain of death, though.)