Special, yes. Like Vail, or to a lesser degree Grand Junction, and many others (even Midway) they present their own challenges. If you closed down all the airports with a special “hazards” you’d be left with Mid-continent and even then you’d be contending with the occasional dust-devil.
Besides, being classified as a special airport by the FAA isn’t that big of deal. For many reasons, I’m not going to get into that with you here, though.
I’m not thinking of closing San Francisco International at all. In fact, they are making improvements to make it safer. No matter how safe they can make these airports, it is the pilots who make the difference. And I am not going to second guess what happened with Asiana Airlines Flight 214. We will wait for the experts to give their report.