While I agree that appending the word no at the end of a statement – thereby making it a question – can indeed sound accusatory, condescending, or confrontational, I don't think that's necessarily the case.
As Charles mentioned, it can also be used to express self-doubt, as if to say: "at least I think that's the case, is it not?" or, "wouldn't you agree?" or, "I could be wrong about that, please correct me if I'm mistaken."
As with anything else, much depends on the context: the relationship between speaker and listener, the tone of voice, the preceding conversation, facial gestures, and the like. But here are a few examples where it wouldn't seem much more of a challenge than adding "eh?":
I'll bet you had a good time on vacation; the weather was good there, no?
That hotel has the nicest staff, no?
1955 was the year that Brooklyn finally won the World Series, no?
That said, I agree with Mitch: it's not a common construct. Being rather concise, it could easily be misconstued to sound very curt. Use it with caution, no?