Deftones' "My Own Summer" is in Drop Db, not Drop D
I've also seen it played in Standard Eb which is pretty much the same just all the chords are moved up a half step.
The only other one I know off the top of my head is:
Linkin Park's "What I've Done" - Drop D (can be played in standard, but more than likely the band plays it in Drop D)
In theory, you could use a midi splitter to feed the midi into a computer, and
have the computer software 'retune' your guitar while you play.
Not sure if anyone has tried that yet, but I don't see why it wouldn't work.
After a quick read through of the thread, I didn't notice anyone mentioning Free Bird. There's a section about a non-standard tuning for at least one of the guitars: http://en.wikipedia.org/wiki/Free_Bird#Slide_guitar
Namely, the B string was tuned down to a G. I don't own a pro guitar, but I experimented with my acoustic guitar, following along with a YouTube video of the chart, and IIRC (at least parts of) the solo sounded wrong if played with a standard tuning, but correcting for the tuning down made it okay.
Someone with actual guitar experience could maybe verify.
idk for sure and apparently nobody else does either because everyone is playing it in a different tuning and in different ways, but if you want to play along with the chart in RB3, it most definitely is in Drop C.