Ghorpm: Am I the only one who didn't like the storytelling part of Chronicles? I admit, at the beginning I thought it was cool but then... well, getting a wall of text every two or three rounds became more and more tiring. I was getting frustrated but then I had a revelation - those massages do not affect the gameplay or at least not significantly - sometimes you got/lost resources but since you cannot avoid it - why should I bother? I stopped reading them at all.
Perhaps it's because the gameplay of HoMM3 is so absolutely brilliant that it eclipses other aspects of the game and therefore the story seems to be a bit weak when compared with other titles.
Anyway, my favorite campaigns are probably those which were directly connected with Might and Magic VII (my favorite from the series). And the best was Long Live the Queen. When I was playing MMVII I either decided to create and independent Harmondale kingdom or join Erathia. I've beaten the game several times but I've never sided with those pesky elves.
I am with you on this. Chronicles is fun for what it is, so long as I skip through the crappy, overdone 'story'/walls of text.
I think the Armageddon's Blade and SoD campaigns were the most fun for me but Heroes 2 + PoL were good also.