This Dream from Advanced Challenge was also my favorite of the AG ones, and it's my second favorite out of all the intros. Like you I feel it has a very nice somber and dark tone that meshes in well with the tone of the song. My favorite, Johto Journeys, has a starkly different tone: a very upbeat and happy tone that meshes in well with the adventure feeling of the song.
I couldn't agree more with you on the TPCi era intros. Pretty much word for word how I feel on them (except personally I like Black and White more than Rival Destinies, and I'm NEVER going to used to the first Diamond and Pearl intro).
Both of my favorite intros come from the 4Kids era, though (for me, 3 and 7).