Here's a list of known songs, and their known effects:

Nocturne of Shadow: Calls/Wakes Him up

Goron Lullaby: Makes Him go to sleep, unless He is enraged

New Wave Bossa Nova: Allows certain people the ability to talk

Elegy of Emptiness: Gives Him some kind of new power, or so He claims

Song of Time: Opens doors and moves blocks