i didnt think god of war games would be very good either, im not much of that type of gamer lol, but i played one of them at a friends house then ended up taking it home and finishing it, then bought the others :)

Flower (PSN)
- best DL-only game I ever played and one of the most unique and surprising games of this gen (on any platform)

The Secret of Monkey Island/Monkey Island 2: LeChuck's Revenge (PSN)
- HD remakes of two of my most favorite games of all time (I recommend them on any system available ^_^)

Red Dead Redemption - one of the best multiplats this gen

Prince of Persia (2008) - not a masterpiece but I love the art style of this game

Valkyria Chronicles

Uncharted 1 and 2

See what I mean courage ? 

Action/Acton Adventure/Hack & Slash

• Ninja Gaiden Sigma
• Ninja Gaiden Sigma 2
• Castlevania: Lords of Shadow
• Devil May  Cry 4 
• Yakuza 3
• Yakuza 4 (when released)
• Metal Gear Solid 4
• Metal Gear Solid Rising (when Released)
• Biohazard 5 Alternative Edition ( RE5 Gold Edition)  
• Team Ico Collection
• Uncharted
• Uncharted 2
• Bayonetta
• Vanquish

Platformers/Action Platformuers

• LittleBigPlanet 2 (early next year)
• Racthet and Clank Future: Tools of Destruction
• Ratchet and Clank Future:  A Crack in Time

2D/3D Fighters

• Super Street Fighter 4
• BlazBlue: Calamity Trigger
• BlazBlue: Continuum Shift
• Tekken 6
• Soul Calibur 4
• Marvel VS CaPCOM 3

RPG

• Demons Souls
• Valkyria Chronicles
• Final Fantasy 13
• Final Fantasy Versus 13
• Eternal Sonata
• Disgea 3: Absence of Justice
• White Knight Chromicles 2 (WKC1 Included with better gameplay and online and Graphics)  
• Star ocean 4: The Last Hope International
• 3D Dot Game Heroes

If you like Zelda and Monster Hunter, I'd recommend Demon's Souls.  Though it's far darker than either of those two franchises.

Other than that, you seem good to go.  LittleBigPlanet is the best game on the system, only to be superceded by it's sequel.  I could probably get by playing only those and nothing else, given the quality and quantity of content in both.

not an issue of the game, looks cool looking at ign footage, but tbh, I just don't feel right playing gory games..... it just feels yuck!

Again...its not just about the gore....you're killing pixels, not actual creatures.

After taking a brief look at your collection, I think you might like the following games:

3D Dot Game Heroes

LittleBigPlanet 2 (I know you're already planning to buy it.)

Ratchet & Clank Future: Tools of Destruction

Ratchet & Clank Future: A Crack in Time

(Can't recommend ModNation Racers or Demon's Souls, haven't played either of em'.)

NOTE: These are I games that I assumed you might prefer. If you were asking for my personal opinion, I'd be recommending Bioshock, Street Fighter IV, God of War III and Red Dead Redemption.

a list of all the games you should get:

-1- the 3 ratchet and clanks.

-2-  infamous

-3- dragon age:origins

-4- oblivion

-5- mgs4

-6- read dead redemption

-7- uncharted

-8- uncharted 2

and a bunch of other games.

From what I've played of PS3 exclusives I'd have to say the ones I find myself wanting to go back to are Killzone 2, Resistance 2 Coop, and Valkyria Chronicles. I know you don't like shooters but Resistance 2 coop feels like a mix of RPG and FPS.. I'd put it between Fallout 3 and Borderlands.

Uncharted and Uncharted 2 are great single player experiences 2 times through each but after that I haven't had any inclination to go play it again.

Also LBP and Modnation Racers as well as the R&C games seem to be right up your alley from your Wii collection. I hope if/when you get a PS3 you enjoy it! =) It's a great system.