Being as I have had 3, an LS and two SS-SC's I recommend them. If you go non SS(which are not SC or turbo models) than you get a decent amount of power, 170, they are still as quick or faster than a v8 LS and are nice lil' cars. The SS's are 2.4L's, the LTs and such are 2.2L's w/ 140hp and 150Lbs tq. Turbos and SC's are 2.0L. If you go new w/ the top SS you get a turbo w/ 260HP and about equal trq and they haul ass for a small econobox, looking at high 13's all day. And with a tune from a good tuner you are gonna love it even more. If you go used and find a supercharged model, you won't be disappointed either, stock they are rated at 205 but upon many, many doing dyno's they are actually putting out stock anywhere from 215 to 230.
Styling, I love them, its just my kind of car. Small, light and nimble especially after some slight handling mods. I love my SC and would recommend going w/ a top model, the 2.2 is a great engine but just lacks power and tuning at the moment. I know you may not be into it but its fun to do things too.
Crash ratings? well not curtain but I have seem many threads on the balt boards of accidents and they hold up good, you can get side airbags and all that so you are not just driving a box w/ wheels. Resale, eh, but what freaking american car has that anyway.
Gas mileage? great! I have a good amount of power, about 250-60 to the wheels(w/out the nitrous) and I still can get 35 easy on the hwy, sometimes 40+ and in city I get about 28 or better pending on if I stay out of the boost or not. If you have any other ?'s just pm me or whatever and I can give you the info or point you in the right direction. You well see probably the same in the 2.2 or 2.4. When I had the LS I got like 30 city and 40's on the hwy all day(mine were all manual trannys).
I have yet to get to drive it in the snow but I hear the SS turbo's and SC are not recommended but tires are the thing there. But they are good in the condition, just have a good set of tires and you well be fine. I do not think you well be disappointed in what looks like an LT or something since you said a turbo or SC is out but you may be suprised at the prices if you find an SC used or Turbo(they went to turbo in '08 btw). Reliability is great aswell, but there are the bad apples but I know a few w/ 2.2L that are in the 80K range w/ not one problem and a few have not done any maintance in the sense of anything but oil changes. I think its one of the good buys out there other than a mazda 3 or top range civic. I may be biased but I am being nothing but honest.