I'm not getting the same results you made with the textures. I used a jpeg of the pattern I wanted for the relief and the cutout in revit and what happens is the solid portion is transparent and the transparent is solid.
use Invert Image option
look in the attached file where you can find it under Cutouts options...
I'm guessing not - but does Revit support normal mapping ?
That, in combination with a cut-out / opacity map would work well in getting the mix of materials + 3d effect without the surface being modelled in Revit. It wouldn't work as well from oblique angles - but more perpendicular views would look right.
as you have already open this subject about mapping in Revit ...I would like to add that from my experience is good to be aware what are the limits of a software. I think that in mapping and materials Revit has some limitations.. it can not do everything at a top level. So, why not export the scene in 3ds Max design ( the material are in shared base so they will preserve) and there to add some special objects and mappings (curtains, cushions, organic shapes , complex mappings)...In fact what matters is a good result even that can mean for some people a sort of "betrayal "
Anyway I am , in practice , against overmodeling in Revit (or in any other program), and I think this could be a real danger for people that try to model every detail.......this is a lesson I learnd using 3d Studio release 4 , at a time when computer resources were much lower...but this lesson is good even today.