High eDPI definitely suits lighter mouse better than heavier mouse. Well, this would entirely depend on what genre of game you are playing.
I am preferring 0.75 x 1600DPI, just need to standardise it across my games. I used to play Starcraft at a high DPI, but in those days I was still in my twenties.
The meta of 400 DPI, out. It doesn't mean that you cannot play at a lower eDPI, but in the current time of games the advantage sits with whomever shoots first, pending on your kit, obviously. Just like the good old Quake times when the only real differentiator was armour.