comedown

The unpleasant physical and mental effects experienced as a drug's effects wear off.

"He had a terrible comedown after the party."

A feeling of disappointment or let-down after an exciting or successful period.

"The end of the holiday was a real comedown."