I think "Your Song" is intentionally self-deprecating, a narrative in which the narrator is clearly flawed. It's probably what I like about it most, other than the fact that no other song really sounds like it. A slow, plodding, awkward bit of simple beauty, to me.