Yeah I came here to say this. I'm sure people do take vitamin D to stave off heart disease and cancer but that was never my intention.
I live in scandinavia so every autumn I start taking one vitamin D pill a day to keep my spirits up during the long darkness.
I believe it helps and I have no illusions of preventing any diseases with it, except winter depression.