Suggestion about the most comfortable aero road bike

Heyy guys,
I’m looking to upgrade to my current bike and I’m saving up for a long time to get a top level road bike. Since it’s a huge investment for me, I’m kinda stuck between going for an aero road bike or a typical lighter bike. Where I live, the roads are full of potholes and abrasive surface. What I have learnt after some research from internet is that aero bikes tend to be lot stiffer and uncomfortable. Should I opt for aero model considering the bad road conditions that I have or should I stay with a bike more comfortable and lighter? Can you suggest me any aero bike which also comfortable on long rides as well as reliable on bad surfaces as I’m more leaning towards to an aero frame. Thanks in advance