Self-consistent theory of collective Brownian dynamics: theory versus simulation.