Thanks to Mangata for finding this tutorial. It was exactly what I was looking for.
Using a small hexagonal tile I made in blender, I followed the tutorial to create the shader in ShaderGraph. In game, when a unit explores the world, I shrink (and then remove entirely) the tile above it. Works like a charm.