Really hard to say. It's such a balancing act.
I tend to like tiny, quaint, get-in-get-out airports the most.
Like the ones in the Azores (except for overcrowded-but-still-small Ponta Delgada/João Paulo II). That said, it's not like there's much to eat or a ton of comfort. When I wanted an espresso before an early flight in Lajes, Terceira—where the airport shares the runway w/an American military base—I had to physically leave and go to the cafe across the street, which was both hilarious and charming. Saw a guy on horseback en route. And the flights are often delayed b/c of wind.
There used to be one in Lviv, Ukraine, that looked like an American central post office, w/beautiful columns and a clocktower:
https://www.alamy.com/stock-photo/lviv- ... y=relevant
The only airport I would ever call "magical" or "charming." Alas, it has since been replaced by some shitty glass structure.
It's been seven or eight years, but Santa Fe had a small, pleasant, user-friendly airport.
Really comfortable airports w/lots of choice, however, tend to be overwhelming and sterile places. They too often feel like shopping malls crossed w/bus stations.
Can't think of a large one that I actually enjoy. LaGuardia is massively improved in recent years, at least.