Flew to and from a little GA airport to see the eclipse in a Cessna 182. Flew commercial from a little airport to a big airport on a Cessna Caravan, and then flew between major airports on A319. The flight on the Caravan was probably the most pleasant commercial flight I’ve been on.
For the 182, your pretty much have to know someone. There might be some sightseeing charters, but only 3 seats seems a little small.
For the caravan, your best bet is with small commuters operating under part 135. Try from a major city to a little but not too little city https://www.iflysouthern.com/ I’m sure there are others, but that is the one I know of.