The only truly interesting Skyrim marriage I've managed was when I console-whipped the game into allowing my female Imperial character to marry the Jarl of Falkreath. We walked back to Falkreath from Riften, rather slowly, and he attacked just about everything between the two cities, but once home he did little more than sit on the throne (unless I got to it first, before 8 AM, then he'd stare at me all day.)
So, we moved to Solitude, and he spent all of his time at the alchemy table or at the enchanting station. He slept on the rough sleeping bag in the storage room on the ground floor, but seemed to be content, somehow managing to run a "store" and paying me a tidy sum now and then. Got bored, and moved back to Falkreath, and he... attacked everything on the way that wasn't a guard. Good times.
He has a creepy line, "You and I are the only two people in Skyrim worth loving. That's what I think." Nobody else knew or cared that we were married, but being the Thane got me off the hook on some grisly charges of murdering a few town guards. Honest Injun, it was accidental! But, in my limited experience, marriage in the game is a monumental waste of time, except for the bonus you get for sleeping in different rooms
