Not the nordic kind that will literally cause you and everyone in the room to vomit

That is not the Nordic kind. You are referring specifically to Swedish surströmming. Regular pickled herring is something quite different in Scandinavia. And they don’t come in tins but in pickling jars.