Doom was OK but I never heard of Red Faction lol...
I think there are few games which were fun to watch based on games. Nothing amazing maybe and forgettable but enjoyed watching them.
Prince of Persia
First Resident Evil Movies (Especially the very first one)
Tomb Raider was quite fun with Angelina Jolie.
and maybe maybe Max Payne.
Oh and Final Fantasy. Was an animated film though.
However majority of the movies based on games are still bad I agree.
But Warcraft looks fascinating. It is a highly budget movie with decent actors. Should be entertaining.