I am with the OP on Casivir and Elanee. They were horrible characters: boringly dry, self-righteous and generally unlikable. The "self-righteous" part I would have been okay with, but neither character ever developed in a way that made it even remotely interesting.
Miranda in ME2 was vapid and silly.
Drunken and/or Scottish-derivative dwarves as a genre staple need to be ... un-stapled. This includes Oghren, even though I liked the overall portrayal of dwarves in Dragon Age relative to, say, your typical D&D fare.
Still, I'm hesitant to just sweepingly say, "No characters like X." As noted above, negative personality traits and so-called vices can still result in great characters. I don't mind being annoyed or pissed off, so long as the reason is a believable, relevant aspect of that character (e.g. Sten being a jerk), as opposed to something I merely regard as poor design or execution (e.g. Neeska's dialogue -- dear gods, please strike her down).
Beyond that, I suppose I'm not a big fan of tropes when it feels like they're just filling in the blanks.