Hi @sheltiesrule
I do work for an Australian pet insurer, if you have any specific questions I might be able to help (without selling anything).
From an insiders view, its like health insurance. Depending on which insurer and which level of cover is what you get. And you generally only get value out of it when something bad happens.
I couldn't even insure my own dog with the company because he was over 9 years old, it's just like us humans getting old, they know you're going to cost them money so they either don't insure you, or charge you a fairly high amount. But, just like health insurance, you're taking calculated risks, you could pay thousands over the decade or more that your dog enjoys, and hopefully you don't have to use the insurance, and therefore it was "a waste". Or you could be one of the less fortunate owners who have to endure hardship when their dog gets sick, in which case you'd be glad you had pet insurance. For me, I prefer the peace of mind having it, and just factor that into my monthly expenses.
What you have to realise upfront is that the older your dog gets the more you will pay for the insurance, they all do it.
Also, be mindful of waiting periods. Most are really good and have 30 days or less, but for certain things like cruciate ligament damage, most insurers have a 6 month waiting period, so even if you have insurance, you have to be careful for 6 months.