The best gas mileage you will get out of a small suv is max of 19-20. one that isn't ridiculously small. the escape is ok but weak engine, maybe a jeep cherokee sport or classic, early 2000 or late 90's model, they have strong inline 6 engines (that last forever if taken care of properly) and are comfy, but ride rough. they are rugged, easy to work on, and parts are cheap. even the 90's models can be bought for cheap.
I guess I'm partial to jeep since I own one.