We use it to prevent temperature loss overnight, especially at the start and end of season when running our heat pump. For that, yeah, well worth it. It saves like 3 degrees of temperature loss overnight, which translates directly to money saved on heating costs.
If you aren't heating, it will still work to keep your water warmer by eliminating the overnight temp loss, if that's something you want.