Seriously, DC could not do better for those two roles in this current climate.. so if movies with them tank, it really isn't them - it's a production issue that is failing.
We all saw them in the movies, they looked awesome.
Frankly, I'd love to see more of both in future movies. There is hope for Ben Affleck he is back in Aquaman 2, and Cavil is been heavily rumoured to appear in Black Adam 2, which if he does and that movie is a hit, getting rid of Cavil as Superman would be stupid.
But I heard it was the old Warner heads, like Anne Sarnoff that wanted to get rid of him, which is why a new contract wasn't affirmed. They say Cavill was difficult and demanding, but grapevine was that he was standing up for the fans, and they were trying to undercut him because actually Sarnoff and co wanted Batman and Superman replaced by Batgirl and Supergirl - and this is the motivation and so called source of "Cavil being difficult".
i mean if this is true, it makes sense, Cavill is an A grade list actor, you have to pay him accordingly, not try to get him dirt cheap, if that is your only way of signing him, you know full well he won't agree with it, and you would "let him go" and can blame it on him for being too difficult or greedy, when secretly you' are the one balking cos you want a different direction for DC
But off course, she is gone, and Zaslav reportedly wants Superman and Batman to be the front runners of a DC universe as their biggest heroes.. which off course makes sense. and Ben Affleck and Cavil are almost universally loved as Batman and Superman, even by people who didn't like the movies they were in that much.