Hm. Akumajo Densetsu, Shin Megami Tensei II and other chip-extended FC games "cheat" in a way by using special mappers, but I guess they can be said to count. Recca/Summer Carnival '92/whatever it's called, that's one. SMB3 is great stuff too.

Super NES? Holy cow. DOOM and Yoshi's Island push that Super FX chip big time, and in terms of awesome amounts of detail (even for a later release) Demon's Blazon is not anything to laugh at, either. I found Takara's Maten Densetsu pretty darn interesting; Otogiriso's successor - er - is certainly a contender as well.