My two favorites spots were the catacombs and dukes. You got all types going through there, and those maps allow for some awesome use of the environment. My most memorable invasions were always either in the catacombs or anor londo. I didnt have a ton of memorable invasions in dukes, but it was very consistently interesting and fun for me.