David E. Davis, founder of Automobile magazine was known to ask "Is your life a rich tapestry?" instead of the usual "How are you?". I like that.
There's this sort of...meme, I suppose, of perfect dialogue. You can see it a lot in the way movie characters talk to each other, especially the ones who are supposed to be intellectual. Think of characters like Tyrion Lannister, Robert Ford, Chuck Rhoades or Andy Dufresne.
They're not just preternaturally witty - they have excellent rhetorical poise. They don't open conversations directly, they gracefully meander to their point with some kind of obscure arcana or quiet intensity. They're theatrical in their delivery and flush with metaphors, analogies or double entendres.
That's the way I feel about questions like, "Is your life a rich tapestry?" That's not a question that's asked or spoken, it's a question that's written. It's so pointed and so raw that, at best, you'd think the asker is eccentric. If you're less charitable you'd think they're simply socially awkward. Opening conversations that way is flying too close to the Sun.
I feel that the best way to answer that question is to turn away from the person asking, as if lost in thought. Then you'd make your way to your answer circuitously, by first deflecting to talk about the origin of the word "tapestry" itself alongside some powerful childhood memory about your father or a famous quote made on the eve of war. Finally, you'd arrive at a delightfully disarming answer that gives a real insight into your life and experience.
But in actuality I'd probably be asked that at a social gathering and respond with some sort of befuddled, "Er, what do you mean?" while being utterly taken aback at the penetrating intimacy of the question. Later on I'd probably ask someone, "Hey what's up with that guy, did he self-help book big on provocative conversation starters or something?"
If you really want to go down the route of non-traditional greetings, I'd recommend, "What have you been reading lately?" or "What are you about?" They still require some situational awareness, but they're a lot less risky and polarizing. I enjoyed being asked those when I first heard them.
It's a great question because if it draws out a rude response like yours, the questioner knows to not waste more time on small talk.
Would you really accept being asked my imaginary question about your spouses sex life from any ordinary aquaintence? Why not? It's free help! You should always want your spouse to have as full and rich a life as possible, and it's too easy to forget that a big part of their life is actually subject to your level of effort and imagination and bravery.
The original question is essentially personal on the order that we usually place on sexual or health matters.
The best word is "inconsiderate" in that it literally fails to consider, or considers and ignores, that many, perhaps most people's honest answer would have to be no, and further, the process of being asked and answering forces everyone who had to answer "no" or "not enough", to recognize that "no" isn't just a harmless answer like what flavor of ice cream you like, where chocolate or vanilla or "I don't like ice cream" are all equally fine. No they are forced to confront that "no" is a failing, and therefor that they fail at something, and that what they fail at is nothing too important, just life itself.