There have been loads of songs written about London and many of us have a personal favorite. I'm quite partial to Ralph McTell's Streets of London
. It's clearly melancholy but also full of hope.
I've put together a list of Songs About London
but I'm sure you'll have one you'll want to add so you can that here