This is not fancy but offers pay as you go as well as short term passes http://www.florentiafitness.com
If you're over 65, all LBHaringey gyms are free (off-peak ie 9-5 Mon_Fri). This may not help you but it's not widely advertised.... The one at Tottenham Green was redone last (?) year and is now well equipped and clean.