The Clown Prince of Crime
Super Freak
The best of those films did the least well financially? Naturally
It kind of makes sense. Check this out, the first film made a ton of cash because it was the first Spiderman film ever, and it was pretty good. However, by the time SM 2 comes out, the novelty of seeing Spidey for the first time on film is gone and some people didn't love the first film enough to go watch SM2 in theaters. But like you said, SM2 was the best, so naturally those who didn't see it in theaters saw it on DVD and the financial and critical success of SM2 probably helped SM3 make more money. I wouldn't be surprised if it has the biggest opening weekend of the trilogy. The expectations were pretty high for SM3 if I remember correctly.