The belief that a cup of coffee stimulates the brain and makes drinkers feel more awake is a myth, a new study shows.