Okay they said this game was released under the PS3 Greatest Hits Selection and I have not seen this in any store anywhere in the country. Was it that bad they stopped selling it I mean it's only two years old now.

I don't understand. It was a really good game (in my opinion). I can't see why stores are not selling it. I know that Capcom released that with Dead Rising and Lost Planet in a collection. It could be that because there's no trophy support. I could be wrong. Your best bet is to look online.

i've seen the 'greatest hit' sticker on the sealed game with the regular clear plastic case at Sears. haven't seen a red plastic version.

I've seen the regular game with greatest hits pricing.

I bought one about  two monts ago, but I live in Mexico so I can´t help you

I did, but Im in the Philippines, so...

Did you check the bargain bins?
That's not a shot at the game, it's just generally where I see it in the stores these days.

I know a lot of people who didn't like it as it was quite different in direction compared to the previous 3 by departing with the main hero for someone that looked just like him (it'd almoist be like if at Super Mario 3 you were given 1 choice with playing a toad dressed as mario). You can probably find it cheap online regardless of being in the greatest hit catagory or not.

I saw the GH version here (Venezuela) about two days ago and actually considered buying it, so I guess it exists.  
 
Edit: Oh my, didn't see the date, oops. 

It had the old PS3 greatest hit sticker thingy a while ago. I think it's just out of print now

I just bought it few days ago on Amazon and it had the Red Case which was kinda shocking to see when I bought it.