I don't feel anybody else has my problem:
Can I get real, here, ratanon? Let me turn this chair around, and my baseball cap, too.
OP, the ones who do know you exist - those are the people you want. Nothing like a time of invisibility to let you know who values you. That doesn't mean you shouldn't try to be someone who is noticed. Maximize that halo effect, bra.
My SO indicated that my awkwardness got to her, and it just hit me that when she said we "lacked sexual chemistry" for the past few years, she meant she lacked a strong sexual attraction. I think she just likes me as a room mate/cleaner/provider and friend.