I'm assuming we're talking about RPG Maker specifically? There were a couple.
Master of the Wind is always the first one that comes to mind; it introduced me to a different stylistic approach from the standard fantasy fare with its use of comic book-esque storytelling and mainstream music. I remember there was an AMV built into...what, chapter three? That featured The Offspring's All I Want and I always thought that was neat, even if the execution, in retrospect, was kinda clumsy.
Quintessence always intrigued me because the battle system was completely event based IIRC. Also, y'know, the OST was the shit.
Other than that I generally just took notes from different mapping styles. I came to realize at a point that I am invariably shit at actually making games beyond "hey this is a neat concept" so I mostly focused on level design and made attempts here and there to subvert the expectations my players would have based on the common tropes of the genre. It, uh, didn't always work.