Is it true that alcohol cooks off completely?

No—alcohol doesn't fully evaporate during cooking. After 15 minutes of simmering, ~40% remains; after 1 hour, ~25% remains. Flambéing burns off more but not all. For those avoiding alcohol entirely, substitutes like broth or juice are better choices.