Hex crawl tips and tricks needed

 I'd like to add some hex crawling to my current Yawning Portal campaign and I'm looking for any guidance anyone can offer. My thought is to add some hooks to each dungeon that gives clues to the next. The PC's then get to do some overland travel to reach the next adventure site.  Anyone have a suggestion for a map/tile set that would work well for this? I went thru the marketplace but I didn't see anything that I felt matched the scale I'm looking for and had a 'realistic' look to it. Is there a way to reveal each hex as the players explore it? Any other tips or products you can suggest? Thank you!

Fog of War is your friend on hex crawls.  Either no illumination or global illumination and just reveal hex's as their explored by unveiling fog of war.

Another way to do this is to use Dynamic lighting, and place tokens representing settlements, or key locations, on the map as they discover them, making each token a light source.  As they find things, it gradually reveals the map, and you can also pre-place some things that they would already know about (such as locations of capital cities, or easily recognized landmarks, such as a mountain).

If you go the Dynamic Lighting Route, you'll probably want to keep the light radius very small and place a light source in each hex revealed,  else you'll end up with a few lights on the points of interest and a bunch of darkness between them, even if already revealed.  Could work nicely htough.

A DM I play with using hex tiles does the dynamic lighting style and sets the town up to have vision, a party token with dynamic lighting, and he has a drag and drop light source token he hides on the map layer behind everything when we discover new areas. You can literally set the token up as a character sheet and just drag it to where it needs to be and right click it and move it to the back. Works great for us!

Fair warning though, if bandwidth is an issue, you might want to use the Fog of War approach, as loading a large number of light sources could take a while to download.