Some adcom members do get excited to see a letter from someone famous. (The VP of a college or university is not likely to be "someone famous" in the eyes of adcom members.) That said, the content of the letter or the fact that the applicant had a letter from a famous coach, politician, or Nobel laureate is not a plus for the applicant.
A useful letter provides information about the applicant that the writer has observed personally. The writer can vomit into the letter every detail from your resume but that stuff is aready on your application. (e.g. repeating that you have volunteered with "Best Buddies" for 2 years and are president of your fraternity.) On the other hand, if an instructor can, after even one class, describe your ability to engage in class discussions, be supportive of fellow students, to write well argued papers that makes use of appropriate source materials and organizes it in a cogent fashion, to think clearly and so forth, then you've got a good letter.
If you had a professor with whom you went abroad or who was responsible for some experiential learning, those letters tend to be what adcoms are looking for.