Sure, if they do it right
The way modern Bioware does it is the wrong way: everyone instantly wants to mount the main character. Pretty much no matter what you say or do you're successful. The romances are just there for wish fulfillment and, in my opinion, can become rather offensive since they turn women, men, gays, straights, what have you into nothing more than sexual objects.
I much prefer BG2's style where you have both work for them and they feel natural in the way the NPC's react.
Also, the point of a good romance in these type of games should be to further characterize party members as well as the player character. Player characters can be somewhat hard to characterize and a good romance is a tool to be used for that end. If the romance doesn't characterize and/or add to the gameplay in any way however, they should just be left out.