I like Fake Bake and St Tropez mousse, they are a browner colour than some others, different ones will suit different skins, but I found Piz Buin too orange for my skin tone.
The St Tropez comes out like a mousse which you rub in in circular motions over your skin, it is slightly tinted so you can see where you are putting it.
The Fake Bake (my favourite) is like a thick chocolate sauce which you apply all over, then go to bed on old or dark coloured sheets (dont try and rub it in cos it doesnt rub in). Shower when you wake up in the morning and all the excess washes off leaving you with a very even tan - it is virtually impossible to streak!
In both cases make sure you wear thin gloves during application!