To pull of a campaign type RPG map you need:
INSANE TERRAIN, HUMOR, EPIC CINEMATIC, EPIC ITEMS, PLOT i am afraid that all these areas need work
10 Ideas to help you with your map:
1). The starting Cinematic needs work, the abomination just walked off the first time I played and the second it just sat there slowly killing stuff.
My suggestion is: Make it able to be skipped! Make a special abomination for the movie clip and increase its movement speed and attack damage and attack rate by heaps so he kills everyone really quick! So its really short and sweet
2). What is will only one type of undead, I was tired of killing zombies like 2 min in. Try changing the different enemies. Give them some cool powers!
3). Terrain, Terrain, Terrain. Needs work! Spend some time and really do up the terrain. Try and make it a bit more realistic!!
4). The end! Cinematic Repeated like 5 times in a row, try turning the trigger off!!
5). perhaps make it a bit more obvious where you need to walk to end the game. I was walking around waiting for more enemies to come and attack the base.
6). You left off some pathing maps on the houses and I just walked through some of the village buildings.
7). Add a bit more description and a story!! Why have the undead attacked etc!!
8). Make the enemies drop items like in the campaign mode of warcraft 3
9). Think about making the game more on your toes, the game gets really repetitive and boring quickly.
10). Add custom spells, models etc. Really go to town! Play Diablo warcraft 3. Thats the type of model you should be using to base your map off.
hope this helps Dragon-Fire