As much as I like The Artifact, running season 4 can be problematic because of the whole Barovia thing. Characters can spend downtime days to get out, but it can still be off-putting to players if they're going into Barovia for just one adventure.
Some of my favorite old adventures:
DDEX2-14 The Sword of Selfaril - Features some social and political intrigue, but also offers a short dungeon crawl.
DDEX3-7 Herald of the Moon - Has a cool "dungeon" at the end which takes place on top of a massive tree rather than underground.
DDEX3-9 The Waydown - The first half provides some great social elements, while the later half provides underground travel, exploration, and dungeon delving.