Sounds to me like you're leaning towards the bigger engine, which will be good for hauling some gear, with the hatchback and fold down seat including front seat you will be able to fit quite a bit in. That's what I love about hatchbacks, I used to have a VW Golf which I loved and the Matrix is great as well, I recently fit in some 9' lengths of trim for redoing my wood floors no problem.
A few weeks back there was a certified 09 S down here but I checked last night and it's gone....oh well. If you get the previous gen you will also get the popping open rear window which is no longer offered on the new gen. It's up to you now if you want the 'slightly sporty small wagon' or the 'visually awesome body lines'
I took a look on edmunds at the 09 reviews and at a score of 9.0 most of the reviews I read seemed very positive.