Median 2008 is a really popular mod. I'm pretty sure it basically just changes the entire game. I've never tried it myself, but I think it's probably the most popular mod for Diablo 2. You can find plenty of videos of it on youtube.