Great answers from both. I might have marked Unreal Sensei’s video as the solution due to bias, but the Quixel article also offers good solutions (World Aligned Texturing, Pixel Depth Offset, Distance Field Mesh Blending, and Runtime Virtual Texting - Just writing those down in case they could come up on a search result).
Appreciate the help. Cheers.