Most people I've worked with over the years have understood their limitations and would never consider themselves great, with the possible exception of half a dozen or so folks, who truly are great.
My opinion is probably tainted by my own working experiences. I've run into various mediocre IT pros who have been at it for a while and possibly are trying to appear smart for purposes of job security.
I've only had the pleasure of working with a handful of what I considered truly great programmers. I don't think a single one of them considered themselves to be "great" even though I thought they were.
Most people I've worked with over the years have understood their limitations and would never consider themselves great, with the possible exception of half a dozen or so folks, who truly are great.
There have, of course, been exceptions, too.