@Whiskey: Have you played CoD Modern Warfare 2 or Black Ops? I own MW2, and have played a lot of Black Ops, and I have to say, they are A LOT of fun, both of them. IMO, even their campaign is very good, although it is clearly not something you'd think "Wow, I want to finish the campaign all over again!", I guess these games are not focusing on SP campaign too much, so its ok.
After 'growing up' on almost entirely Battlefield-style FPS games, I just can't do CoD. It doesn't work for me. I can do objective-based (like, blow this up, capture this, etc.), but I can't do CoD-style
Well, there you have it. CoD MP games, are more suitable for "rash type" FPS gamers, while Battlefield are more strategical and serious. You can think of it like that: Battlefied + Unreal Tournament = CoD, sort of.
You get the "just kill'em all!" feeling of UT, but on a Battlefield scenery 
But overall, I love both BF and CoD game series, although I do not own any Battlefield games, but have played them quite a lot.
Woah woah woah... did you genuinely play Reach for the plot Twilight? It was obvious what would happen. You'd fight a losing battle, see the entire cast die, and then go out in a blaze of glory. I personally loved the campaign gameplay-wise, but as you said, plot sucked.
TBH, I didnt even watch the cut-scenes of Reach when I played it, I just skipped through them, mainly because I wanted to continue playing the game, killing more alien stuff, and couldnt be bothered to watch them, lol 
But overall, Halo Reach isnt really a sequel to Halo 3, so I dont see what the big fuss about the plot is about.
"My Pokemans. Let me show you them"
