Walter Mitty

An ordinary or ineffectual person who indulges in fantastic daydreams of personal triumphs. From James Thurber's 1939 short story character.

Examples:

• He's a Walter Mitty about riding in a rodeo but is actually afraid of horses.