The biggest issue of most videogame adaptation flops is that they're not really inspired in the source material. But usually are a different original script with a paint coat of franchise. As a result they fail at being good as part of the franchise, but they also fail at being good as something original because they're dragged down by the expectations and precedent of the franchise the script is being forced upon. Halo being the biggest example, the writers and show runners even bragged how proud they were they didn't played the original games.

Counter example, the Warcraft movie is actually good fun because the scriptwriters really knew the lore and understood what makes up WoW's essence. Part of the problem is producers don't take videogame as a serious art medium. Similar to the problem that animation has, where some producers don't think of animation as real cinema.

Something based on Bioshock, either the first or the second, would be amazing as a movie, not just visually but because there's quite a human side to the story, from the tragedy that beffel those in what was supposed to be utopia and what was done to those who became Little Sisters and Big Brothers to the megalomania of its maker and even the whole wiff of Fascism in the politics of the place before it fell.