Per your link

Alabama: 404

Alaska: Redirects to the index.

Arizona: prohibits consumption of alcohol or other mind-altering substances as a defense against criminal charges. No mention of drunk victims. However, Arizona state law adds 3 years to the minimum and maximum sentences of a sexual assault offense involving the use of any of several substances. Remember when you objected to the idea that mind-altering substances can be used to impair your ability to consent?

Arkansas: Does not appear to allow searching based on crimes or keywords. Different source "A person commits rape if he or she engages in sexual intercourse or deviate sexual activity with another person: ... Mentally incapacitated;" I'm having trouble finding where Arkansas has defined "mentally incapacitated", however they do have this definition for an "incapacitated person": "Incapacitated person" means a person who is impaired by reason of a disability such as mental illness, mental deficiency, physical illness, chronic use of drugs, or chronic intoxication, to the extent of lacking sufficient understanding or capacity to make or communicate decisions to meet the essential requirements for his or her health or safety or to manage his or her estate.

So, it's not looking good for the idea that drugs and alcohol don't affect your ability to consent.

California:

If an individual has sexual intercourse with someone, the crime of rape may occur under the following scenarios described by California state laws: Intoxication by alcohol or drugs impaired the victim's ability to consent. The defendant knew or reasonably should have known about the victim's impairment.

Colorado: Invalid link from the index

Connecticut: Sexual assault in the first degree again refers to mental incapacitation, defined “Mentally incapacitated” means that a person is rendered temporarily incapable of appraising or controlling such person’s conduct owing to the influence of a drug or intoxicating substance administered to such person without such person’s consent, or owing to any other act committed upon such person without such person’s consent."

Delaware: No mention of alcohol that I saw. However, rape in the first degree is partly defined as "Any of the following misdemeanors: reckless endangering in the second degree; assault in the third degree; terroristic threatening; unlawfully administering drugs; unlawful imprisonment in the second degree; coercion; or criminal trespass in the first, second or third degree; or"

So, we're back to some substances can be used to impair the ability to consent to sex, therefore rape.

Florida: No mention of alcohol or impaired mental states in the summary provided by your source. "Under Florida state laws, the prosecutor needs to show a lack of consent, but does not need to show resistance or protest."

Georgia: redirects to the index

So, in the first 10 states alphabetically (I skipped DC because I'm already doing your homework and I just didn't feel like it), 4 are dead links or uninformative. Of the remaining 6, 5 mention alcohol and/or drugs can be used to impair the victim's ability to consent.

California's state laws in particular directly contradict your assertion that "Not one of them says that a person cannot consent just because they are drunk."