Insurance write-offs explained: Cat S, Cat N and older categories

What the write-off categories mean, the pros and cons of buying one, and the questions to ask.