Is HEA the best ending?

Is every romantic novel supposed to end with "and they lived happily ever after"? Is the mystery diminshed when the reader knows in advance that eerything is going to end with the heroine in the hero's loving arms? Or is the pleasure of a romance wrapped up in the journey vs. the destination? What do you think--reality, rose-colored glasses, or something in between?