First off, Welcome!
As for fuel economy, I've had two FWD Patriots (2.4/CVT & 2.0 5-spd). Both will deliver 30MPG if driven easy. Not surprisingly the 2.0 5-spd does a little better. If you've got any AWD system you'll use more fuel if for no other reason because you're dragging around a heavier drive-train. Likewise, any automatic tranny will never be as economical as a standard. Finally, an FD2 is not at its best on the highway.
Patriots are reasonably fuel efficient but only if driven easy. When I say I'm getting the low 30s, I'm doing 50-55 MPH on rural highways. My 2.0 5-spd put out 30+ on the northern stretch of I-95 in Maine where the speed limit is 75 and I might have nudged the 80s, but there is literally no traffic there. It's pretty flat and I used the cruise control.
Comparing a Corolla and Patriot is not even an Apples:Oranges comparison, its an Apple:Turnips at best. In a swamp or a snowstorm you'll be glad you have a Patriot. Otherwise the Corolla is probably better suited to the purposes you describe. Unfortunately you may have purchased the wrong vehicle for your needs.
Oh, Patriots have very small gas tanks. Do your math, don't go by the gauge.