My personal opinion is that if someone is visibly drunk and you want to get into bed with them, even if they are consenting, -you- should say no and wait until they're more sober so you can make sure they weren't just drunk talking. Even if they are insistent.
If someone got really drunk and told you to take all their money, it's would be common decency to realise they're really drunk and in reality would rather to keep their money. Not sure why it's so different when it comes to sex.
If you were genuinely interested, it's not like it'll kill you to wait and find out whether they meant it, is it?
And if you were just hoping for a quick fumble and you're a bit desperate... not to be massively crude, but just go home and 'relieve your frustrations' yourself.
Considerably less dodgy than getting it on with someone who is probably not going to remember consenting, or anything that happened the night before.
This goes for both genders. Unless they can look you in the eye while entirely sober and go "Yes, I would like to have sex with you" then just don't.
No, people shouldn't get so drunk and be more responsible for themselves, but they do, and they don't, so hey.