Subdividing based on vertex weight value

I am looking for a solution to subdivide a mesh based on weights per vertex.
Any suggestions on this ?

So the artist would vertex paint a mesh with a value.
The value would decide how much subdivision those polygons will need.

This way we can control resolution of a mesh where it is needed for our productions.

We can be flexible with the tool so if it would be possible in houdini, maya, blender, zbrush …
we can adapt :slight_smile:

Any suggestions in tools that can do this ?

thanks !