So as to not derail the other thread, I’m posting my reply in this general off-topic place
I wouldn’t say one other exclusive appearance of the character would constitute Sony being pretty pig-headed about the character. Insomniac (a usual Sony partner) went to Marvel first to seek out one of their IPs, they came out with Spider-Man.
What we have with Avengers is a big-budget RPG live-service game featuring stunt-double variants of popular Marvel heroes, and Sony trying to cash in on that success and recent release by dumping money on Square Enix to get exclusive rights to the bonus character. Too bad it kinda failed, but some would say that’s ultimately a good thing.
In the case of Ultimate Alliance, Nintendo may have forked over more cash than Sony to get the entire thing exclusive to their console (not much Sony can do there).
And currently, there exists a game with Spider-Man alongside plenty others in his rogues gallery: Fortnite. Both a comic-book version and a Tom Holland No-Way-Home version, available to all. (There have even been Comic Venom and Tom Hardy Venom sold in the shops before.)