Bungie should definitely include a horde multiplayer mode.
Gears of War had one, it was lots of fun.
CoD has Zombies
ODST had firefight.
It could be set on existing maps and/or with some new specific maps with increasing levels of difficulty per wave and/or have a Wall Defence mode where the City is laid siege to and a fire team has to repel the attack.