For the men who take Viagra, it solves a simple ‘mechanical’ problem. But for their wives and partners, the drug’s effects – on everything from their self-esteem to their sense of security – have been far more complex.