You aren’t wrong here. But I think the break down comes from the definitions of can’t miss.
The only true can’t miss prospects I remember were
Shaq
Duncan
Lebron
Brow
Zion
The next closest was probably Oden but his knees had enough red flags that he didn’t make it.
Any of those guys could’ve been Greg oden though. On that point I do agree with you.
Shaq didn't make the Olympic team. He was too fat, couldn't shoot, and was too raw. Duncan was too slow and not athletic enough to be a true superstar. Lebron was a can't miss, but there were quite a few who thought Carmelo might be better in the long run out of that draft.
I think everyone knew Brow was going to be good, and some thought exceptional. I think Brow ends up looking a little better in this discussion because he is an all-star and so many #1 picks have been busts in recent years. FWIW, KAT has had a monster February and March, and will be one of the best centers in the league heading into next year. He was a first pick of the draft that some had semi-written off as just another good player because he took an extra year to break out.
Other "Can't Miss" prospects that I can think of from the last 20 years:
Darko Milicic - a more polished version of Kevin Garnett. Kind of Doncic before there was Doncic.
Michael Beasley - college scoring machine and an amazing athlete.
Lonzo Ball - I think people know he was a little overhyped, but he was considered a transformational player.
Jabari Parker - scoring machine that could play 3-4 positions
Joe Alexander - I don't know that people expected a superstar, but no one expected him to suck as bad as he did.
Alex Len - a lot of draft boards had him at #1 in 2013.
Good article on the 2014 draft:
Excited About The NBA Draft? Let's Revisit The Failed Promise Of The Wiggins Draft
Another one (Trigger warning, Thabeet takes a beating in this article):
Biggest NBA Draft Misses of All-Time