Also a colorful term from the late 90's pothead culture - a one-hit wonder is a person who displays all the symptoms of being really, really stoned after smoking only once (i.e., taking one hit). This is generally indicative of either inexperience or just plain foolishness.

See: lightweight, amateur.