Here's my verdict on everything I've tried:
Nivea self tan spray: This was ok, a good colour but I found that it got difficult to clutch the bottle properly whilst spraying when your hands got wet with self tan. The bottle kept slipping about.
St Tropez: A little streaky but the colour is nice - very brown. Stains clothing when you haven't washed yet, takes forever to scrub your hands afterwards (I know - gloves lol)... I find that the tan has gone in about 2 days which is a pain.
Lancome Face Gel with Vitamin E: Fantastic, not too dark, leaves your skin feeling nice. Skin tans about an hour after application.
Lancome Cream: I haven't used this for ages (not even sure if thats the correct pic but the bottle was very similar) It's nice but a little orange occasionally streaky
Estee Lauder face bronzer and self tan - awful! The colour is completely off, especially if you apply foundation afterwards. Its a new product so they will probably improve it soon.
Simple Cream: Ok, very light though - probably good for a person who doesn't want a full on tan
L'oreal Sublime Bronze tinted self tan: Fantastic colour and just great because it gives you an instant shimmery and natural looking tan so if you're going out you look fab straight away. When you wash it off you still have a tan. Lasts about 5 days which is good!
My personal fave is L'oreal Sublime Bronze Gel: It lasts a week, leaves your skin feeling soft, non streaky, natural colour, has vitamin E in it (I love vitamin e cause it heals the skin).