Well, I didn't play Skyrim that much, but I ended up marrying the archer girl with tattoos and stuff. Forgot her name, but she was in the companions guild I believe. I wanted to marry Lydia first, but it wasn't possible if I recall correctly. For me, I think it's because I was playing an archer, so it just made more sense to have a ranged companion, otherwise she'd be in my line of sight all the time. And she was more or less the first "available" (for lack of a better term) spouse so I just went through with it. Plus she had good artwork, and that counts too.
But I didn't feel emotionally involved at all, if that's what you're asking. She was just another companion to me, perhaps prettier to look at, but that's about it really. The extra bonuses were nice, but the game was so easy already. Frankly, I didn't pay too much attention. I never found very attractive the concept of interactively involving the player's romantic feelings in a video game. Just like the whole phone dating thing in GTA IV, I never really caught on. Feel free to disagree, though!
My spouse met her fate a few days after the wedding to one of those rotating spikes, regardless. She will be missed. Sort of.