SkeleTony: Heroes 4 was not very good overall but it is not as bad as when it was first released, especially if you use the Equilibrius mod. IMO you can skip Heroes 4 and not miss out on anything Heroes-wise.
Kadlin: I think the 4th one is great. You have heroes on the field of combat, can have more than one, and they add a lot to the tactics of the battles. Unit choices add to tactics, that's all very different from the other Heroes of Might and Magic games.
Heroes get taken to prison, so they have a sense of loyalty in the 4th one. And prison? That's a great concept, add a bit of Lords of Magic gameplay elements to it, and it would be even better.
I wouldn't say that others could skip Heroes of Might and Magic 4 and not miss out on anything, it has so much good stuff none of the other ones have.
All in my opinion of course! I don't use any mods for it, all regular good olde Heroes of Might and Magic 4.
I said you can skip H4 and not miss anything HEROES-WISE. I will leave up to the individual to decide whether Heroes 4 is a good or great game in itself but it is not really a Heroes of Might and Magic game for the most part. It is as different from Heroes III as Warlords 4 is different from Heroes III.
EDIT: And without using the Equilibrius mod you have the problem that Heroes 4 had the worst AI imaginable. Even one of the developers visits a few message boards detailing why the AI was so bad and what happened that resulted in this travesty.