It was nearly a theme park, a football stadium and a Vegas-style hotel, but none of those outlandish proposals for Battersea Power Station ever got off the ground. Now, thanks to a £400m cash injection, work will finally begin on transforming London’s favourite landmark into a residential pleasure hub. Richard Godwin takes one last look inside the long-suffering icon