Okay so there's this city and a bunch of sick people and you're supposed to hit a bunch of things with your sword to find the cure, and then you go to other places too.
Neverwinter Nights (the original campaign)
You are a soldier and you go to a tiny island in the middle of nowhere to punt off a bunch of Russians that plan to blow up another small island in the middle of nowhere with a small population and no strategic purpose in the hopes of starting world war 3
Operation Flashpoint: cold war crisis
You play a farmboy who gets turned into a wolf, then back again, then wolf again, then back, ETC. Then he finally gets to choose when to transform, and in the end saves the world from a sword-swinging pig-beast man guy.
Legend of Zelda: Twilight Princess
In a society where fuelless steam engines are the norm, are used only to drive trains and the idea of maybe some sort of organised schedule for the world's rail network has never occurred to a anyone, one kid must drive what appears to be a barrel on rails from a small seaside village to a castle without fucking it up and become a train engineer. Once there, shit hits the fan, the evil cunt of a chancellor destroys almost all the tracks and plans to do bad, bad things to the former princess's corpse and the newly inaugurated engineer has to get himself a magical train and fix everything that asshole fucked up.
That said, the music kicks ass.
Legend of Zelda: Spirit Tracks
You sneak through the jungle and eat a lot of animals and also you look at this lady's fake boobs also there are these guys who carry an emotion into battle and your medic talks about old 50's and 60's B movies and stuff.
Metal Gear Solid 3: Snake Eater.
There's this game that takes place in this fantasy land that totally rips off WoW because it has elves and humans and dwarves and gnomes (called hobbits in this game) on the side of good and orcs and trolls and zombies and goblins (who are apparently also related to orcs, lol wut) on the side of evil. No matter what you play, you're a wimpy character because these black robed people always make you cower like a pussy during cutscenes. You run around, saving pies and doing so many escort missions. The classes are basically paladin, mage, warrior, rogue, priest, hunter (it's even named the same, lol, they were too lazy to change the name but they didn't even give the class a proper pet. wtf.), warlock, and then there's guardian (basically warrior without the dps, lol) and warden (wtf, it uses a stupid skill system)
Oh yeah, you also use wasd to move around, and the number keys to use skills. I mean seriously. Could they have ripped off World of Warcraft any more? Oh, yeah, they did. The main villain is totally a rip off of the Lich King, just with fire instead of ice. Seriously, man. SERIOUSLY. And his servant is even called the WITCH KING. I mean, SERIOUSLY! Ugh. I give it a 1/10.
Lord of the Rings Online, from the perspective of a WoW fanboy
You begin on an island with the desire to become a pirate, but in order to do so, you must complete tasks like find a buried t-shirt and steal this ugly idol thing from a mansion that's guarded by weird dogs. It takes you about two minutes to fall in love with the governor who lives in that mansion, and you're completely heartbroken when she is kidnapped by a creepy ghost pirate guy who wants to have her to himself. You have to go find your new love and defeat the ghost pirate guy with root beer.
The Secret of Monkey Island
You play as a red and yellow guy with unattached limbs trying to get his flag back.
Plok (http://en.wikipedia.org/wiki/Plok)
You are a young Arabian girl who listened to the agonized voices of others, which had convinced you to go on an adventure. You even get a flying bird-kitty who later becomes a fat ball of fur (who can't fly) as your pet not even half way through the game. Also, the music is great, but it's the same tune as the theme.
Monster World IV (http://hardcoregaming101.net/wonderboy/wonderboy4.htm)
You're building a wall, and some asshole keeps knocking it down. Sometimes you only have to put up with it for, like, five minutes tops. Other times, you have to wait until your wall exceeds safety limits in height and the government makes you take it down. It's really a lesson in bureaucracy and destruction of property.
Tetris
http://www.youtube.com/watch?v=hWTFG3J1CP8
Fly around in a bunch of antique plains and occasionally unlock stories of said plains.
Secret Weapons Over Normandy
You're a ship who transforms into a woman (and back) who travels a giant eye. Inside the eye you fight blobs, Roombas, robots and other weirdos, and the environment is diverse (for instance, there's an ocean floor!). You can also trick out your weaponry by either finding them, winning them against creatures and buying them with chips.
The Guardian Legend/Guardic Gaiden (http://en.wikipedia.org/wiki/The_Guardian_Legend)
An American bartender possesses the body of a disturbed Italian in order to discover where the Pope keeps his apples
Assassins Creed: Brotherhood