How sober should a writer be?

Should writers be stone cold sober or tipsy enough to believe they are an amazing writer?