Only good adaptation from video games has been Sonic and that’s only because they saw the writing on the wall in terms of the outcry.I like your optimism but my pessimistic hope in movies these days is always screaming "THEY'LL SCREW IT UP!" lol
Anime adaptations and I’m really racking my brain here to think. Probably, Alita at least decent story and financially successful. Although some do have a cult following on the Guyver adaptations.