Hexatraction is perfect for the nose of a SUP, I use only it now.
A similar product is Van der Wall.
www.waal.co/ Cheaper, more packaging options (you can actually order the amount you want), and may be even grippier than hexatraction.
It may not be grippy enough for high level longboarders, though: a good wax job stills provides more grip. And I guess you can get sore feet if using it for the paddling position, as there is no cushioning.
I do not think it will work for dogs, their claws will just skid on it, they will not get the purchase a soft pad provides.