Here is my input.

I do not think we have a clear cut on your questions.

Generally speaking, when there are many users and objects are huge, we may need to use NO_LOCK. Our decision is made based on our the above factors and the torlerance of our users.

NO_LOCK may cause insistencies if we abuse it, however.