**Core Concept**
In cholera, the Gs subunit of the G-protein complex is modified, leading to an increase in intracellular cAMP levels, which in turn causes the secretion of water and electrolytes into the intestinal lumen, resulting in watery diarrhea.

**Why the Correct Answer is Right**
The modification of the Gs subunit is a result of the cholera toxin, which is produced by Vibrio cholerae. The toxin ADP-ribosylates the Gs subunit, preventing its hydrolysis and leading to a sustained increase in cAMP levels. This increase in cAMP activates the cystic fibrosis transmembrane conductance regulator (CFTR) chloride channels in the intestinal epithelial cells, resulting in the secretion of chloride ions into the intestinal lumen. Water follows the chloride ions through osmosis, leading to the characteristic watery diarrhea of cholera.

**Why Each Wrong Option is Incorrect**
* **Option A:** This option is incorrect because the modification of the Gs subunit is specific to cholera toxin, and not a general response to bacterial infection.
* **Option B:** This option is incorrect because the modification of the Gs subunit does not lead to an increase in intracellular ATP levels, but rather an increase in intracellular cAMP levels.

**Clinical Pearl / High-Yield Fact**
Remember that the modification of the Gs subunit by cholera toxin is a classic example of a gain-of-function mutation, where a single amino acid modification leads to a significant change in the function of the protein.

**Correct Answer:** C.