The original question is unfair - your favourite song is almost always a favourite song AT THAT MOMENT.
So while 'Waterloo Sunset', as previously mentioned is a masterpiece and in my revolving top five records which take it in turns to be my favourite, today it's not my favourite. Tomorrow, it...