Actually, weightwise, there are automatic transmissions out there - like mine
But mine is no longer made. What Karen (retiredhappy) has replaced mine by Chevy - and it pretty lightweight - what I was looking at if I hadn't found my car. And I like those Cobalts. You know how much we could fit in the car
All I can say - I don't buy new - so I found the models I would consider, and searched until I found one at a good price, and then got the price even lower. Unlike you, I wouldn't do manual transmission. I wanted a car to drive in cities, etc - and I hate manual transmission in cities. Also, when I had my broken ankle - couldn't have done manual transmission. So I think about all of that. (And, unlike lots, I simply hate manual transmission lolol - not saying it's wrong for you). Just don't want you to rule out auto because of weight.
I love my little car - and love even more that it came with some dings, etc - so I'm not worried about it getting more. When I drove through Iowa last week - on the dirt/sand/yucky roads - that car looked so bad - just hosed it off
Good luck on finding what will work for you.