While DC Comics' Batman has had quite a successful video game career thanks to the Arkham series, the same can't quite be said for the company's other flagship superhero Superman. There have certainly been Superman games, but none of them are particularly well remembered. The only one with any real staying power is Superman: The New Adventures for the Nintendo 64, better known as Superman 64 AKA one of the worst games ever made.
The last game to be explicitly about Superman was in 2006. Since then, fans of the Man of Steel have had to make do with him making playable appearances in other games, like a couple of the Lego Batman games, the Injustice fighting games, and soon Fortnite as well. But it's recently been discovered that a Superman game was in development from 2007 to 2008 at Factor 5 (the studio behind the Star Wars: Rogue Squadron games), only for it to be canceled when both the studio and its publisher went out of business.
The details come from a lead designer on the project Salvatrix on Twitter, who even shared some early test footage. Codenamed Blue Steel, the goal was to feature "super brawls" similar to what was seen in the comics and cartoons. Justice League Unlimited in particular was apparently a major source of inspiration, with the team putting together a montage of clips from the show to demonstrate what they were aiming for, including the famous fight between Superman and Captain Marvel (known nowadays as Shazam) and Supes' final confrontation with Darkseid.
It would have involved aerial brawling, crashing through buildings, shockwaves from the impact of hits, environmental damage, and then some. The team didn't want to hamper Superman's full capabilities by relying on the traditional crutches like kryptonite and robots as enemies. Instead, he would've gone up against enemies of similar strength. Some examples, judging by shared concept art, included the aforementioned Darkseid, Livewire, and Doomsday.
Although it wasn't made to be a tie-in, it would've released alongside a sequel to the Superman Returns movie from 2006. But that was also canceled due to poor box office performance, which eventually led to DC and Warner Bros. rebooting the movie series with Man of Steel.
Further details can be gleaned from the full thread on Twitter, which also includes some concept art. As for the future, DC's next major game release is another Batman title, Gotham Knights. After that, though, is a Suicide Squad game, which will feature Superman in an antagonist role.