There is no song in Gypsy called "I Had a Dream". There is "Rose's Turn" which is considered one of the greatest 11 o'clock numbers ever written, if that's what you mean. The random and cheesy lyrics would be by Sondheim.
The two cheesiest songs ever written for musical thatre have to be:
Happiness - You're a Good Man, Charlie Brown
Do Re Mi - The Sound of Music
"What can you expect from a bunch of seitan worshippers?" - Reginald Tresilian