I have noticed that when I take diphenhydramine my dreams are more vivid and I remember them upon waking.

Diphenhydramine is the active ingredient in Excedrine PM but most other over-the-counter sleep aids have a higher dosage.