I have discussed this with my agent on more then one occasion. the best advice you could get on this subject is to talk very truthfully with your insurance agent about what your wants, needs, and desires are when it comes to coverage.
I can get comprehensive insurance only for $50 per year. It will cover fire, theft, animal hits, things that are not my fault. I only looked into for the theft and maybe the fire. currently the trail truck has no coverage of any type.
obviously carrying collision on a trail vehicle is useless as you are going to dent it and collision only covers your vehicle not others. Liability is what will pay to repair other peoples vehicles damaged by yours or peoples property damaged by your truck.
Do you drive it to the trails? I trailer mine. I have comprehensive coverage on the trailer. If its stolen I'm out a couple of grand. if it catches fire its gonna cost to repair the wiring and wood deck. so for $22 a year it was a no brainer.
If you roll the truck and get hurt your personal health insurance should cover you. if you burn your house down your home owners insurance should cover it.
So after all that, my advice is talk to your insurance agent. bring up any and all scenarios that could occur. If you have a good and honest agent we will point you in the right direction.