It kills me when people say Cassandra isn't a woman. Because she doesn't fawn over you and doesn't need you to swing a sword ? She's her own person. If you romance her and grow to enjoy it, good for you. If not, she has stuff to do. In that I can see Morrigan, who is quoted so much as the ultimate romance, and still go see to her own business at the end of DAO. Yes, Morrigan was interesting ; she is so much more than a sarcastic ******. Just like Cassandra is more than an angry armed manly wall. But then, is it Morrigan personality who compelled you to follow her romance, or her second pair of eyes ?
Now, if it's about aesthetics, Cass' is not beautiful to you. Beauty standards are not universal. I'm a woman and she is charming to me. Also, the scar ? Totally hot.
Solas, although not conventionally beautiful, turned out to be a smooth charming bald guy. I don't see people complaining that he isn't hot enough ; I used to mock him myself. But then you plays and spend some time around his banters, and he may grow on you ; that's what a personality is for ; To see beyond. You're a poor sod if you ever felt like Aveline needed to be hotter, Isabela whiter, and Joséphine bangable. It's not who they are, and they're not changing for you. Just like IRL.
Romances, although an enjoyable of BioWare games, are not everything.
Companions, although able to grow and take different directions under your counsel, are not here to be your playthings.
First, you are a woman and we are talking about what most straight males percieve as sex appeal, not about what a woman (I don´t know if you are hetero or homosexual) percieves as having a charming personality, it is not even related.
Second, while they are not universal because there are always exceptions, most males have similar tastes. Take a look at the physical looks of most succesful professional models, you have a lot of Victoria´s Secret vids on youtube, or take a look at the physical looks of most young actress in a romantic role. There are definitely a enormous majority of men who have similar standards in the matter of female sex appeal and Cassandra is not an attracitve woman (or even just a woman) by those standards, and neither Josephine (although she is a woman at least by those standards, unlike Cassandra)
Third, I don´t know if Cullen´s face seems cute for a straight woman (or a gay male), but he is a character with almost every (if not all the) physical trait and personality trait a woman percieves as attractive on a man. He is tall, he is muscular while not being on roids, he is blond, he is strong (both physical and mental), he is mature, he works on a leadership position, he seems hard and rough to his people on the outside but is sweet and caring on the inside and he loves to talk and heard you talking. In other words, he is what we describe as the "Supermodel" romance or "Hollywood supermodel" romance in this videogame, which is the fantasy unreal romanceable character that doesn´t exist on real life, only in books, movies and videogames. Why straight males don´t have any option that barely resembles that in Dragon Age Inquisition when we had it on every pass Dragon Age and Mass Effect game?