I love SSM. It's still my favorite non-comic version of Spider-man to date. And that includes all the films.
The issue with trying to do a SSM though, is that the Norman/Harry twist was one that works much better in a series, and not in a film. They really drew out and developed the "who is the Goblin?" mystery, which was great because they wanted the viewers to have the same anticipation for who the Goblin was as the original readers of the comics did back in the 60s/70's. But that twist was one that needed time to grow and develop before it could be revealed, and I don't think it would be as effective if you try to cram it into a 2hr film.
Now, I could be wrong, and I certainly wouldn't mind if TASM films are taking cues from SSM (best thing they can do in my opinion) but I just think it would be hard to pull off.