Can Kohn-Sham density functional theory predict accurate charge distributions for both single-reference and multi-reference molecules?