Variational Reduced Density Matrix Theory: Successes and Failures