However, it was mostly unnecessary at the same time (save for 4 games) as it just really gave higher resolutions or smoother frame rates and little else...
Well wikipedia is seldom 100% correct.
Yes agreed, that's why I disclose it's from that source whenever I use it. It's fine though for casual discussion.
While I will agree that at least half of your 60 some titles didn't really beneift from the pack, the other half did... it just wasn't so glaringly obvious that it coudl be put into a list.
The most common use of the pack was to up the resolution to a full 480p. This means any game in which precise aiming was required really benefitted from it. Also as I mentioned, it also ups the draw distance, which again improves aiming. I remember trying rogue squadron without the pack just to see the difference and I could barely play some of the fiddly levels.
I could honestly say I've played not even ten of those sixty games on the list. But basically, you
could play without it - whether or not it was ideal is subjective. That doesn't include the four "must-haves". I guess that's why it worked as a peripheral. They didn't have to make dedicated software for a smaller user-base (the typical problem of most peripherals) - it was only some extra memory.
Probably the worst in nintendo history is a three-way tie between R.O.B., the Super Scope and the Wii Wheel. Rob only had two games, likewise with the wii wheel, and the super scope is probably the only lightgun ever released that made lightgun games less fun.
And an honorable mention goes to the power pad... but track and field made it worth it. 
I give R.O.B. a pass as far as peripherals only because it was basically a trojan horse to get the NES into US stores after the crash ("it was an interactive toy and an entertainment center, NOT a video game"). But yeah, it's pretty worthless.
Wii Wheel is nothing more than a case for your Wiimote - the game works fine without it (some, like me, argue it works BETTER without it). At the same time, you can use it for any game that you'd use your Wiimote as a steering wheel (e.g. Excite Truck). It came with the game, so it's fine.
I agree on the Super Scope... pointless. Also, the SNES mouse (though it did work on "On the Ball" [renamed conversion of "Cameltry"]. I think pretty much any add-on where games have to be made specifically to utilize it (like the balance board, 32X if you don't consider it a separate console, etc) will always fall short. But I would move the Power Pad up to top three as it barely worked with games that were made with it.