Honestly, it depends.
The average person in general is unremarkable to look at. That includes both women and men. And the average age in the U.S. is 38 years old.
A lot of the "average" women dudes are thirsting over here are more than likely above average or good looking. But that's not average. It'd be like saying that the average man looks like Morris Chestnut or Michael B Jordan.
For the average woman who I actually am exposed to on an everyday basis, I'm indifferent towards many of them. But there are some women who aren't model looking but still have curvy bodies, cute facial features, or a great sense of style who will leave impressions on my mind.
I'm also in a relationship though so I wonder if that has anything to do with it. Either way, even from the perspective of me being single, the average woman I see out and about in grocery stores, department stores, malls, parks, restaurants, etc. is someone I might have sex with if I were lonely or desperate but I wouldn't go out of my way to date them.
But, of course, good looking and in-shape women will catch attention from anyone everywhere.