It's cleverer and sexier than brains or beauty. Musicians and performers have it spades – but in equal measure to insecurity. So this week let's explore songs all about wanting it, getting it, using it or losing it