Also I'd like to just add that I find sera quite attractive, but I can see how people find her very unattractive, I like strange and abrasive people. Oddly enough I really don't find Josie attractive at all, but like sera it's obviously my opinion, because attraction is subjective, I feel sorry for this guy not understanding that.
Josie has an attractive face to me, she is beautiful. I'd just give her another outfit however. What she wears is horrible ( well it is well designed, and artistic, I mean, horrible in the sense of attractiveness for a straight male like me ) and does no honor to a woman's body. It is possible to be totally conservative with zero skin showed, but still dressed in a way that could attract the eyes of those males. Even leliana is sexier with her armor than Josephine with her outfit to me. Of course, no need to tell me that it wasn't the goal, I'm just having fun talking about this.
Vivienne is incredibly sexy, with her face, and her outfit. Ugh. The first time I've seen her in the stairs hidden behind her mask,seeing the global result, I felt something, like " wow, what a nice and beautiful lady " I had the same face impressed as Leonardo di Caprio in TITANIC, while Rose is in the process of downing stairs !
Morrigan dressed in Orlais was incredibly sexy too. I didn't care at all about seeing Morrigan again in DA:I unlike the fanbase, but I admit that I was finally happy to see her again, and she was so sexy in that dress that I almost wished she was a romance option again. 
Sometime, it's also just a story of attitude. Ashley williams wasn't that attractive to me the first time I've seen her. She suddenly became hot when I discovered her sense of humor, her subtle way to seduce me. Hotter than Liara to me with her personality, while in fact, If I didn't know any of those characters at all, I would have probably chosen Liara first for her physical appearance, especially in M3 where she is very hot.
Cassandra is beautiful to me too in her own way, and she is adorable. I'm just annoyed that her romance arc is not very different from what we have with Josie. The fact that I am kinda forced to be very romantic and poetic kinda kills a bit my love for her. I wish the romance happened a bit differently.
Sera didn't attract me. I didn't understand half of what she said, too strange sometime and too abrasive and not making sense. I am pretty sure that here too, at least for me, that's again a story of attitude. I would find her probably more attractive if I liked her personality more.