I did an install on a 250,000 mile 3.0 Vulcan Ranger yesterday.
Client was a self employed "Jack of all trades". Lawn and tree equipment filled the bed. Electrician and plumber tools filled the cab.
He solved the small cab storage problem by removing the passenger seat.
It was worked hard but ran really well.
If you can work around the limitations of the small cab, a 2.3 or 3.0 Ranger/B-series will serve you well. But you will not get nearly the mpg you were getting out of the Split port 2.0.
HHR LSes are cheap, plentiful, practical, and ecotec 2.2 powered. Doesn't get the mpg of the Cobalt, but you can put people and stuff in it. A lot of people complain about the pinched driver footwells but it didn't bother me.
Then there's the Pontiac Vibe. Everything you get in a Matrix without the extra Toyota markup.
I can't explain why, but I really liked the original 1.5 Scion xB. It doesn't have a lot of power but the combination of gearing and seating position it felt pretty sporty. It was a fun little microvan.