More than 40% of Americans are living with a silent deficiency, but experts warn that while the "Sunshine Vitamin" is essential for longevity, more isn't always better.