I do a little dabbling with music (I use Reason 4) and in a few random dreams, this doesn't happen ever, I created the most amazing / beautiful / powerful songs. The only problem is, it's more of an emotional feeling and I can't ever recall what the actual songs were.