I started playing Euro boardgames with Settlers of Catan in 1995, and have been playing them ever since.
The real place you want to look for information on them is
Board Game Geek.
As far as
Shadows over Camelot, it's a fun co-op game. I've never played it single player, but have played it 8 or 10 times. You may also like
Pandemic or
Lord of the Rings, both similar cooperative games. Of the 3, I like Shadows over Camelot the best.
And if your people are such sore losers that they get pissed, then perhaps you should find a new group to play with. Or start with teaching them some sportsmanship.