Marvel/Disney/superhero fatigue.
That may have a small part, but the Spiderman movies are largely considered outside of the 'usual' MCU scope, and are more Sony's thing. Though, Venom and Morbius didn't do too hot. The Spiderman movies themselves though, for the past few years? They've done great and No Way Home is still considered the absolute highlight post-Endgame.
Now about superhero fatigue...that is interesting and there is a possibility that has set in a bit. Though we could say there's definitely Star Wars fatigue when it comes to the shows, for example, yet the games have lots of fanfare and Jedi Survivor performed quite well at retail. I'm just saying, whatever affects the films and shows doesn't 100% carry over to affect the games, though they could have some small influence or bearing.
But WRT Spiderman 2, like others have been saying, Sony simply haven't kicked off the advertising in earnest. I did complain about lack of Starfield advertising early on, but that's because Starfield is a new IP and MS has a history of lackluster traditional advertising for their big games the past 10 or so years. Spiderman's recognizable AF and Sony usually do very well with traditional advertising for their games. They're just probably waiting until the end of September/early October before kicking things off in earnest.
Still think they'll probably do another SOP for the game and hopefully show off some new gameplay systems & mechanics/features, because everything else looks pretty tight. And at least with the recent photos, the visuals seem improved further notably from the May footage, just hope that translates to in-motion (and that things like the water fluid model is improved vs. what we saw in May).
I think it's exactly this and it's what I was gonna say, though in different words. There have been far too many huge, open world, big budget, and actually fun video games released in too short a period of time. I'm still gonna love Spoders 2, but I gotta admit, going from Tears of the Kingdom to Starfield and now Spoders, and hell I skipped the Harry Potter one altogether as I just have never been a Potter guy, but that counts as well, and I still haven't beaten either of the two aforementioned games as they're just too damn big.....I mean I'll be lucky if I can "beat" either of those games before the year is through. Huge Venom fan though, so I'll have to make special time for Spoders, however I am starting to feel that just three games alone will eat all my free time up, which I don't have much of anyway.
Can definitely see this POV, as I have something of a similar situation. Not as much time to game as in the past, and in my case, there are also a lot of classic titles I have been trying to play through. So many big releases today just swallow you into them with a metric ton of content and playtimes approaching triple digits in some cases. For some of us, that's a game that'll take months to play through. Now drop 5-6 or more of those in the span of a single year; it can be difficult to play them all to completion.
I bought GOW Ragnarok Day 1 for example, and I still haven't finished it. Granted, my schedule is more of an outlier, but it's something I have to consider when looking at what games to play. There are those with milder scheduling situations who still probably struggle with making the time to finish a lot of these massive open-world games in any given year, and I think that's a reason smaller indie games have been getting increasingly more popular over the years. Not only do they usually take less time to beat, but a lot of them are also more mechanically simple, both in terms of controls and game systems, so they're easier to memorize and take a longer break from before jumping back in and quickly getting right back up to speed.
Though, I think part of that also fluctuates based on experience. A lot of AAA games in specific genres for example, have certain standardized inputs and systems between them, just due to popularity of those things. So someone who plays a lot of those games in general just builds up skills and memory for them where even after a long break, they can come back and get acclimated with them in just a few minutes or what-have-you.