mushroomqueen4 said:
So, I have a two questions...
1. I feel somewhat obligated to start with very first Resident Evil game released in 1996 and to play my way up to the latest Resident Evil 6. Do you encourage that? Or is it better if I pick up to a more recent game? (Keep in mind that the story and characters mean a lot to me in games).
2. How freaked out do you get when playing these games? I can totally take the zombies in Dead Island or zombies seen in movies, however, I admit I've never actually played any other survival horror game

Is it more action-oriented or does it have that creepy silent-hill/amnesia feel?
It's fine to play it in order. That's how I did it (through sheer chance).
The earlier ones are showing their age, however, so use your best judgement there. If you try the first couple and aren't too impressed - I'd skip ahead to Resident Evil 4 or even Resident Evil: Code Veronica X.
Resident Evil 1: - Unintentionally hilarious. We had a blast with it, but definitely didn't take it very seriously. A lot of the 'plot' and the character's actions/lines make no sense at all.
Resident Evil 2: - I liked this one a lot better, had a great time traipsing around the police station killing zombies and solving puzzles.
Resident Evil: Nemesis - I remember this one being similar to the second one in terms of gameplay, graphics and enjoyability (it's been a few years since I last played this one so the details are hazy). My overall impression was positive.
Resident Evil: Code Veronica X - This is my favourite of the older games. The gameplay was great, I loved the story and the cutscenes were amazing. That scene where the female antagonist walks down the stairs? Wow. I still love watching that clip. It gave me goosebumps the first time I saw it. The boss fights were a lot of fun as well.
Resident Evil 4: - This is probably the best of the series in a lot of respects, but it was also a bit of a departure from the main formula up until that point so your mileage may vary. I loved it. The Resident Evil 'plot' up until this game was a huge many-headed beast that often didn't make a lot of sense. This game kicked the whole convoluted backstory to the kerb and came up with a plot that was only tangentially related - so it doesn't matter if you've never played any of the others. You can play this one without needing to know anything about the series. The graphics and gameplay got a huge reboot (helped by advances in the consoles) and it's just a great game in general.
Resident Evil 5 and 6: I can't really comment on these. I did own RE5 briefly, but got bored with it pretty close to the start and just... stopped playing. Which is a shame, but I just can't bring myself to try again. I've read reviews of RE6 - they weren't complimentary. I might try it one day. Probably not though.
TL;DR - If you're looking for characters and story you may be barking up the wrong tree. A convoluted tree with pretty one-dimensional characters. If you just go into it looking for a bit of fun, however, you might have a pretty good time.
As far as freak-out factor goes - meh. I'd say low to middle when it comes to scary-level. Most of the scares are from things jumping out at you rather than pure atmosphere. That said, there were a few times when - due to the sounds I could hear/music that was playing/past experiences with the games - I genuinely didn't want to enter that room/open that container etc