I'll try not to repeat any mods:
Isquall on deviantart has Miranda, Femshep, and Liara from ME for races, and the N7 Armor to go with them, and also has a Jill Valentine from RE race that I like.
Caesar's New Regime overhauls the Legion to have decent armor and variations of said armor.
While it's not an aesthetic mod, More Perks and Traits allows for plenty of customization of your character as they level up.
Roleplayer's Alternative Start kinda let's you choose how you start your game, and allows for a bit more customization of your character at the start.
Courier's Cache adds a quest, some nice lore friendly armors, and a small player home to the game.