Everyone's an "odd fish" in my mind. And we all have our own quirks. So we need to work with people who compliment those quirks (I mean . . . go well with them, though the odd "I find your neuroses charming" wouldn't go amiss either). I am deeply neurotic. I end game and send my agent emails like: "Okay, so what if twenty years from now I've got a hangnail, how will that affect book sales at that point?" And she puts up with it marvelously, answering my questions as if they were sane.
I truly don't think it's wise to look at an agent and be honoured that they want to rep you. There's no honour about it. Yes, it's hard to find an agent, yes it's exciting when you do and of course authors feel like if they do just one wrong thing an agent will dump them. But that's wrong. The fact is that an agent agrees to rep you because they respect you. And you want them to rep you because you respect them. It has to be mutual. And you need to work in such a way that is mutually beneficial. If you feel like you can't talk to your agent about anything professional (uh, not so much personal stuff) then that's a serious business problem.
Now, you may have to set some boundaries from the off, and being professional is two sided. Just as they shouldn't be offended that you have questions to ask, you too must keep in mind what a professional question is and isn't. Knowing how an agent is representing your work to editors is definitely under the heading "professional interaction". It's your work after all.
I think instead of thinking of yourself as weird and that no one out there will ever suit your personality, think of yourself as one of many quirky authors who will find that right agent for him. Remember, authors in general are weird. They work alone, they live in their heads, they often shy from the spotlight (uh . . . not me so much, but that's my own brand of strangeness). Agents are used to authors not necessarily being the most socially comfortable individuals. And of all the businesses out there, this is the one where you are most likely to find someone who can work with your quirks.
Don't compromise. Trust me, we've all seen someone who has. And it never works out.