GNR is the best in my opinion and here is why. Slash was actually on the design team. Because of this they spent a ton more money on the game than they normally would. The result is a game that feels like a Williams game of the same era. Not just "shoot the ramp" like a lot of the DE games are. Runners up are JP and TFTC (I'm not a fan of the TFTC theme but the game is good). Star Wars is OK as well (I actually like the soundtrack), but not even in the same league as GnR!
And really, The Simpsons, and BTTF, and Hook, and any other early DE games are completely linear and have really weak rulesets. I have owned or shopped all 3 of these and they are fine for casual playing, but the question WAS which was the best.
And I'd like to add: I'm not a fan of Guns n Roses (The Band) - it's just a really great pinball machine.