It just plain depends! if you can manage stress well and as everyone else has said your looking for a particular trinket at level 5+ this is when you really want to go. Jute Tapestries and Puzzling Trapezohedrons are always top tier, naturally, along with the minor and major antiques from the antiquarian.

Onyx is *maybe* worth it, but I've usually had bad luck with getting a full stack which would make them worth more than a gold stack (save with an Antiquarian in the party). Don't bother picking up gemstones of a lesser value than Emerald (so, Emeralds, Sapphires, and Rubies). In fact, make a point of prioritizing which provisions you actually have a use for, which Food & Torches most often being the last to go. If you have a Hound Master's doggy treats, use those up early while not totally wasting them to make space. Antivenom is pointless to bring for almost any dungeon's curios besides the Weald (there's something in the Cove but it never seemed worth it to me). Always make sure to only bring the provisions that make sense for that Dungeon Region, so 3 or 4 shovels for a Long Ruins run, while taking 6 shovels for a long Cove or Weald run. I've generally found long dungeons to be profitable but it's harder to get a good number on the provisions to bring, and you have to be careful in prioritizing your inventory (more so in Long runs, I mean).

Troubling effigy darkest dungeon