In the gold saucer in FF7, quite a few fun mini games. The Bike chase is great. even the little basket ball game is fun!
But the best is the roller coaster ride where you have to shoot the targets. God, i played that mini game so much, i can STILL remember where and when 90% of the targets will show up.
Breath of Fire 3's Fishing games were FUN. I prefer that fishing game over Ocarina of Time's fishing game.
Man...i'm having trouble thinking of other mini games. Honestly, I can't remember the last game i played in the past 2 years that has an actual mini game in it....Been a ton of side quests...but i can't really remember too many Mini games...
Developers need to put Mini games back into games dammit!!