Mm, depends on the game and how well it's written. Felt a bit silly in Dragon Age, but I felt more than comfortable in Persona 4: (Persona 4 spoilers...I guess it's only for if you don't know who the playable characters are)
Romanced Rise Kujikawa and felt this sense of joy by the end of it, especially in the wyas she had developed...then got pissed off when I was one rank of courage off of starting a social link with Naoto...oh well, 2nd playthrough should do the trick