I've never liked the sharp object transitions typical of video games, but yes, I think that this technique only really works in specific circumstances.

I think it'd help a lot of the terrain geometry were distorted such that it looks like it's physically interacting with the object it's blending with (e.g. sand resting against the side of the object). If that were added to this technique I think it'd be a lot more convincing.