My best gaming memories have always been with friends or cousins growing up with local multiplayer. Whether at LAN parties or going at a midnight launch and playing that entire night doing co-op of the games story campaign or PvP, nothing beats that experience.
I'll always love single player games as well but I'll always prefer local multiplayer.