I'm trying to think of an airport I could compare it to but I don't fly much on the east coast. On the west coast I would say it'd be like a SMF or OAK or PDX (without the Intl service). Probably half the traffic is 737 type aircraft, the other half RJs. WN has a decent presence there.
I think you'll be pleasantly surprised as long as you're OK with connecting on longer trips (east coast or international).
Nearly all of JetBlue's transcons eastbound are red eyes. I believe that's how they started as an airline (hence the name)