Had no experience of protected no claims on a bike and claims. My wife and I have it on her car insurance and I totalled it 2 years ago ... my fault
claimed on the insurance with no effect to the NCB or renewel the following year.
I've protected my NCB on the bike for the last 2 years, cost is quite low and I think it's worth the expense.