SIPC insures up to $500k in securities and cash ($250K limit on cash) at member broker-dealers. There's no insurance against loss in value of the underlying asset; however, in the event of a bankruptcy of a broker-dealer, the first $500K of your assets are covered. The remainder would likely be fine as well, but you'd have to wait for some of the bankruptcy to play out.
As to OPM's original question, I would not worry about insurance limits at a firm lije Vanguard, Fidelity, T Rowe Price, etc.