Helllooo! So I just wanted to have some sort of a conclusion or closure to my experiments so I ended up making a Houdini Digital Asset to automatically fracture any mesh however you like and the pivot points are automatically baked into the UVs. No Texture is loaded and everything works great out of the box. I’m very proud of this because I had this theory and I practically applied it and made it work 
The shader for the above gif.
Some other quick experiments trying out the workflow with the tool.
And here’s the Houdini Graph.
Spent all day trying various meshes in various orientations, sizes, rotations and everything works! 
!
I’m not fully happy with the HDA though, there’s a few things I want to try and I also want to look at automatic material creation (if I can even do that) so I can use python or some other scripting along with these to make a one click solution and use that for something else in the future.
For now, I’m tired and sleepy. I think I’m going to work on an FX next.
(Sorry for your bandwidth loss, I’ll look into optimizing my gifs next time D:)
I was pretty sloppy on the actual HDA itself. I can definitely add a lot of options for the fracturing, masking, weird sliders and parameters but I’ll save that for some other time.