Does SELECT * create additional overhead even when you want all columns?
Strictly answering your question, no there is no additional overhead when you want all columns returned.  But it is undesirable as you mentioned. I do not want to reiterate why it is undesirable as most of the points are discussed in this answer.