Insights into correlated electron systems from first-principles quantum Monte Carlo