That "impotence" made him legit happier for a while, which is not what impotence actually does, at all, you sure you're not having a weird interpretation of this? Specially considering this was a plot point that happened in the comics, and Spider-Man 2 just used the same beats.
It originally worked like Daredevil's enhanced senses, annual 1 even calls it a radar, directly compares both and says Daredevil's senses is a better version:
And we kinda see that a few times, like in ASM#4 where he used it to walk in the dark:
https://i.imgur.com/qYncAlJ.jpg
Don't ask why he even needs Spider-Sense to walk on his own home when it's dark lol.
Green Goblin also talks about it in ASM#26 like it can be avoided if he's fast enough:
https://i.imgur.com/Zyxx7J7.png
And apparently it affected his eyes too, or at least something like it, since in Annual#1, he could use it to read a message that was in a piece of paper he covered in thin web:
https://i.imgur.com/lpg35BY.jpg
So yeah, it wasn't a "predict only danger" shit, it originally was enhanced senses.
Wonder when exactly it became a "predict danger" kind of thing, at the latest it was done by Conway, since during the original Clone Saga, there was that whole dumbass thing of "Spider-Sense only protects against enemies, not friends" with Jackal from ASM#148:
https://i.imgur.com/Er1KydZ.png
Which, while really dumb (And contradictory, since Spider-Sense did warn him in the same damn page, only too late), it might be what started this "Spider-Sense only detects danger".
Alledged venom anyways, since it doesn't work like any actual venom, it's just bio electricity, or a win buttom when powered by Bendisforce.
I can see where they're coming from, since a lot of inventions are based on something else, so I can see why they'd make Spidey "finish" what someone else did.
While it's dubiously canon, Spider-Man/Fantastic Four#2 has this moment where Peter said he based his webs in "synthetic polymers" Reed made for space suits, so even 616 went for that at some point:
https://i.imgur.com/eieGfjp.jpg
Though, here he only used it as a basis and made the web of his own, not finishing what someone else started, which is nice.
Ah, I knew that something once said that the spider bite is what made him be able to make the web formula, but wasn't sure where that came from, thanks for that.