I don't think they're all ugly, but I do think pedestrian safety regulations and the quest for aerodynamics has taken a toll on some of them (Uh hem, Nissan).
IMO, the Camry has come a long way, looks-wise. The last time I liked the looks was gen 4, when it was almost indistinguishable from a Maxima, from a distance. But this current generation, while a little overwrought (I'm not a lover of fake vents) looks good. I'd actually own one, if looks alone was enough.
The modern cars that hurt my eyes are the thankfully-departed Nissan cube, Scion xB, Nissan Juke and Honda Element. They appeared deliberately ugly, as if visually offensive was the goal. I don't think aerodynamics can be blamed for these, as they were all rolling boxes, except the insect-looking Juke.
The last time I truly loved the looks of an Accord was 1993. They caught my eye again in 2015, but by 2018, they'd uglified it again when they joined the blunt-nose, huge grille trend.
My favorite design right now belongs to BMW's 8 coupe, which surprises me, because I haven't liked the looks of any BMW in a very long time.
There's beauty to be had out there, but most of it carries a steep price tag.