Where are some little airports with big experiences? Dining. Shopping. Activities?
that contradicts “little”. Running dining, shopping, activities is done to make money. “little” airports are never that busy that it is worth.
What is your understanding of “little”?
I was flying once from Klagenfurt, Austria. This is a “little” international airport from my understanding. The shops there were open only if an aircraft is planned for departure. Even the person who was at one shop counter closed it and made the check in.
Same happened on Bydgoszcz, Poland.
There is simply not enough traffic to operate a smooth experience.