Rufus Wainwright, cantautor