No good hexcrawls? Really? I didn't realize that was a problem. Everyone talks about Hot Springs Island being the best thing since sliced bread, but I've never looked at it. I ran a hexcrawl at home that worked tremendously which was heavily based on ktrey's '100 wilderness hexes' project, which I never tire of talking about:
Blognard?
blog.d4caltrops.com
I am running an overly-huge city game right now, and Vornheim sits on the shelf ready to go - but almost never gets pulled out. A few of the tables in the back are cool (random NPCs, nobles, etc) and I like the dungeons he included (the Zoo especially, I have incorporated into a larger adventure location - maybe a report on that some day). I have never used the die drop tables or the 'urbancrawl rules for slacker DMs,' preferring a looser pointcrawl approach. I don't want to actually keep track of *what street we're on* unless it is vitally important.
Also, I think Vornheim is so distinctive in flavour that it won't fit in most people's games.
For citycrawls, I agree that there is no 'definitive product' that we can rely on. I use a shitmix of stuff I've obtained from all over. My application has not been consistent, varying based on how I'm feeling, how prepared I am and where we are in the session.
- Melan's Nocturnal Table is fucking great (and its predecessor, Matt Finch's City Encounters)
- Judges Guild - City-State of the World Emperor (Has its flaws, but some great shit inside. I have not yet gotten around to the original CSWE)
- Midkemia Press - Cities (old, but has the right idea)
- Courtney's On Downtime & Demesnes
- the odd bit & piece from Vornheim
- Ben L talks about citycrawling on his blog, and I like his approach -
http://maziriansgarden.blogspot.com/2020/10/rules-for-citycrawling-in-dreamlands.html (He looks at it like a pointcrawl, but the connections between points are amorphous. You have to find them by going exploring in the city)
- Last Gasp's Corpathium rules -
https://www.lastgaspgrimoire.com/in-corpathium/ (very specific flavour, but the encounter tables are pretty good)
We are just scratching the surface of city-adventuring though. My players have not yet realized just how MUCH STUFF there is in the city to do, as usual my hints are too subtle.