Sure, Deus Ex was a shining beacon of level design and plot arguably not matched to this day (though prequel Human Revolution came close).

FORBES: 13 Classic Games Made Awesome with Mods, part 1