Vitamin D only really has dramatic effects in people who are severely deficient. Despite all of the influencers and podcasts claiming it's a miracle supplement and that we're all deficient, actual Vitamin D studies don't show much or any benefit outside of people who are significantly deficient.
But yes, if your Vitamin D is actually low then getting it into the normal range could have some dramatic effects.
Some doctors will prescribe short courses of Vitamin D as an almost-placebo when they can't find anything else wrong. It works quite well as a placebo for many people because podcast health influencers have been talking about it so much lately.