Fish sauce (on Thai or Vietnamese food)
I’ll eat any kind of cheese, no matter how bad it smells. Except limburger, which tastes as foul as it smells.
I guess I’d have to say crab. And even that I won’t cook in my own house anymore.
Are you speaking of Nuoc Nam sauce? Because that doesn’t stink. It just smells like fish.
Stinky cheese. I have had some Stilton that took weeks to move out of the house, smell-wise.
Roquefort.
Liederkranz cheese
Their slogan used to be “Once past your nose it tastes great.”
I had a fish taco once that was a bit past its prime. But, I paid for it so I felt obligated to eat it. Well, actually I had a ‘coupon’ so it was free. In any case it was…difficult.
Pickled herring is one of my faves. It’s the one and only time NO ONE will kiss me. 
Now that is one thing I won’t put in my mouth. I grew up downwind of the pickled herring factory. It was pretty evil on a hot summer day. My memory won’t let me even try it.
My mother loves it though.
I loooovvvve pickled herring.
I never noticed its smell. I guess I would if I lived downwind of the factory.
I guess garlic. Kind of a boring answer, and while I can appreciate the aroma, it comes with bad childhood luggage (see here). Still, now that I’ve grown accustom to the house filled with the smell of garlic when some of my favorite foods are being prepared, and learned that the smell = awesomeosity! – there’s still that cringing boy, recoiling in the recesses of my mind; under my mind-furniture.
Having deep Sicilian ancestry and family makes this unpopular to admit. 
The smell of ketchup nauseates me, but comfort food wouldn’t be the same without it. Most fermented condiments smell nasty in quantity but taste good when applied in reasonable amounts. Soy sauce. Vinegar. Marmite.
I like the smell of garlic, but I don’t like the way it makes me or other people smell after eating it.
Durian Fruit - frozen, sliced thin and then mixed with Vanillia ice cream. Actaully freezing seems to reduce its odour signifigantly.
Lutefisk… I love it, but my wife says it smells like primitively preserved, half fermented fish. I explain to her that it is exactly that. Then I brush my teeth for 10 minutes if I want any kisses.
Veitnamese fish paste… an ingrediant in Pho` (Noodle soup). One brand smells soooo bad but, it makes the nicest soup and the smell disapears as soon as it hits the boiling water. It smells bad, like low tide, on a hot day. Yrs ago my cat (sorry no pic) came into the kitchen while I had some open. I lowered the open jar down to moggy’s nose level - it took one sniff and back up, crouched and staring at me as if to say “You are gonna eat THAT???”
I bought some Gruyere cheese that I thought smelled very foul. I don’t know how it ranks on the foul cheese scale, but that’s about as far as I can go. It tasted pretty good though. Don’t know if it was worth it.
Keep in mind that this thread is not just for things that smell bad but taste good, but also for things that are vile that you have some other reason to ingest, such as my Valerian capsules in the OP.
Well, that would be the aquarium water you have to drink before having a colonoscopy. My father gave it the name and it has really stuck in everyone’s heads. Even my doc has taken to the description.
I guess most people would pretty much ingest anything willingly if there were a good enough reason for it. If the medicine you needed to save your life tasted like pig shit, there probably wouldn’t be too many people who’d turn it down.
Or are you looking for things that people do willingly ingest, rather than would?
I see someone has never been to a town in Vietnam that manufactures the stuff. Let’s just say there is a certain air about the place.
Do, have, would reasonably expect to, etc.