A Wild Magic Sorcerer with the Deck of Many Things, Deck of Illusions, Wand of Wonder, Bag of Tricks and Bag of Beans.... Let's gamble.

The alchemy jug actually had an impact on a campaign I ran. We were playing "Tomb of Annihilation" and my players had great difficulty scavenging for food, and thus sustained themselves on mayonnaise for repeated bouts of week long expeditions into the jungles of Chult.

I played in a campaign where my friend was a collector of magic items that was his whole character basically. We were early on in the campaign and he found a home brew magic item that was "lightly cursed" it was called the wand of eye gouging. You picked it up and had to make a decent wisdom saving throw or immediately jab yourself in the eye with it. Didn't do a ton of damage or anything but you could lose an eye. Well once we had both sufficiently messed up and jabbed ourselves he decided to use it on enemies. Pulling it out and loudly announcing he was gonna use his "Wand of Fireball and that its super powerful and expensive" only to cast too hard and accidentally throw it towards that enemy or "drop" it. So many of them fell for it.

the Alchemy jug always reminds me of Grog from critical role conjuring mayonaise and eating it with his bare hands when he is sad

We found a couple interesting uses for our alchemy jug, both of which involved booze - when we were short on trade goods for the bollywogs who were guiding us to the black dragon's lair, we used it to create beer to bribe them with. After we slew the dragon, we were trying to preserve as much of it as possible - I literally ended up with 350 pounds of "black dragon bones, scales, and horns" in my bag of holding. One of us wanted an eye, but we knew it would rot away. So, we split open a water skin (the mouth was too narrow to fit an eye), put the eye inside, used the Mending cantrip to put the skin back together, then filled it with alcohol from the alchemy jug. Instant pickled dragon eye!

The bag of beans is harmless until someone summons a mummy Lord

I guess Wile E. Coyote accidentally ordered the Marvelous Pigments when he bought paints from the Acme corporation. That, or he didn't read the instructions all the way through.

You can use mayonnaise, in addition to some cooked chicken and bread, to make a chicken sandwich.

Cooking Oil is flammable too.... (This is why cooks are taught not to throw water on an oil fire...)

obviously, the trigger word for the Wand of Wonder is 'wabbajack'

[Party preparing a trap]

a while back in my game the players entered a talent show in a little gnome village. The sorcerer's "act" was literally pulling out a random bean from the bag and planting it. It caused a fountain of beer to spring forth from the ground. The entire village got absolutely wasted and he won the talent show.

Player using marvelous pigments "I draw a Flying Carpet"

"I think it's cooking oil though, not burning oil."

I did a one shot for a mercenary guild and I gave the rogue assassin a rust colored bag of tricks. All the party members had a secret ulterior motive, and the assassin was trying to secretly off the target of the rescue mission.

For a second, I was slightly worried this was going to be the same as the "uncommon magic items for creative players," but then I remembered you guys are awesome and never disappoint. I can always come to your channel for fair, respectful, and in-depth discussion on this wonderful hobby.

I was in a Tomb of Horrors campaign where the alchemy jug was used. They used it to produce mayonnaise to make the permanently invisible beholder visible for 2 rounds. It was to this day the most creative use for that magic item.

I made a homebrew weapon based off the magical pigments: the Paintbrush Glaive. It was for a paladin of the goddess of art. She could use a bonus action to elongate it from a normal paintbrush into the size of a glaive and had the stats of one. It had 10 charges that could be expended to create things following the guidelines of the pigments (we worked together to figure stuff out). Some stuff that she made were a door to knock on when they encountered a half-ogre who got mad that they didn’t ask before coming into his swamp, a bridge to cross a small ravine, a small crate to protect a child NPC during combat, and a door to bypass a puzzle I created (I nerfed this ability as this essentially gave her a free Passwall spell, so it cost 6 charges to only allow her to do it once a day). She loved that glaive

That's a lot of Mayonnaise.. 2 uses I could immediately think of:

I'm the dm in a ancient greece themed campaign. I'm definitely gonna give them the opportunity to do a Dionysus themed quest with an alchemy jug at the end lol