As a resident Marvel game aficionado/weirdo, it's finally a thread for me!
Objectively, I think the first Insomniac PS4 game is the best Spider-Man game now. It's the perfect combination of all the different parts a Spidey game needs. Its got the physics based webswinging, it's got the combat, the constantly down on his luck Peter Parker, the friendly neighbourhood aspect of Spider-Man; it's got the suits that I spend far too long obsessing over. There's totally valid criticisms of it and I have a few, but I think it's undeniable that it's the most fully realized Spider-Man simulator, on an objective level. Never played the second game, heard it wasn't as good; as soon as I found out that it was all about the exact same symbiote/Venom storyline, I was out.
Shattered Dimensions is also pretty peak, it's a great 3D beat em up. It's a shame it's relatively hard to emulate and it never got re-released on anything; I'd kill for a Shattered Dimensions/Edge of Time remaster but it seems very unlikely. Loved how each of the Spider-Men felt entirely unique from one another.
The SegaCD Amazing Spider-Man Vs. Kingpin is I think the best retro 2D Spidey game. I played it for my Marvel article here and it actually surprised the hell out of me as I went in with no expectations at all. It's a spectacular 2D brawler, really recommend it.
And of course, me beloved; PS1 Spider-Man. Subjectively, this is one of the greats but that's entirely personal opinion. It was I think the first game that attempted to fully capture and realize Spidey and pulled it off. Multiple villains, web swinging traversal, combat, stealth, a lot of different suits I also obsessed over, cameo appearances; for its time it was unbeatable. It was also the first one that felt like it was made by fans and people who cared; there's plenty of interviews you can find from the Neversoft devs where they go into exquisite detail about how much research they did, and how they all loved making it. It still holds a incredibly special place in my Spidey fan heart, but like a few people have already said it has not aged the best.