The best airports are the ones most people never visit. They are the 10,000 or so small airports that scatter the country. Most of them don't even have scheduled commercial service; they are just there for private pilots and flight schools. Let me describe a typical experience flying in to one of these airports.
Upon arrival you pull your plane up to the FBO (Fixed base operator – which is a company that leases space on an airport from the county). Usually a lineman is there to meet you and direct you to a place to park your plane. After shutting down the plane the lineman helps you unload passengers and bags. Often they give you some bottled water and a ride in the golf cart to the building if it is far. Inside you give your information to the person working there and, if there is a parking fee (usually there is not but sometimes it is $10 or $15) you pay it. Most FBOs offer free snacks: popcorn, fruit, or candy. You can get a free courtesy car for an hour for free. If you need a car longer than that you’ll have to rent one. Of course, if you are only going someplace a few miles away they will usually give you a ride for free. Usually they just like to talk and ask you questions like “where are you from?” In short, it’s the kind of Southern Hospitality that you hear about in old movies and stories but don’t see much anymore (Side note: I’ve only flown in the Southern US so maybe it is a regional thing).
You don’t have to take your shoes off. Security checks consist of “Is that your plane?” “OK, have a nice flight”. If you want to check out your city and see how many airports you have you can go to
www.runwayfinder.com and zoom the map in on your city. I bet you will be surprised at how many airports there are that you have never heard of before.