Don't forget Double Dragon Street Fighter, and Mortal Kombat.
I never saw Double Dragon, the American Street Fighter movie was probably one of the worst movies ever made (but the anime movie wasn't bad). And I actually enjoyed the first Mortal Kombat but the second one was hideously bad.
I think movies based on fighting games turn out the worst because they try to include every character from the game. No one has any real plot or character development so every character shows up to do their special move and then leaves. Plus it's not like fighting games themselves have a strong plot to begin with so the movie's story is usually equally awful.
The only way a video game could be made into a respectable movie is if it already had a strong plot and characters to begin with. Advent Children might have a chance.