A little tricky to decide how to answer, when you say "some are obvious" - so what's not obvious that needs explaining?
Of examples you give, some, like the Sushi Box, are not a type of effect but a company.
Sushi Box makes a number of different effects pedals. Sometimes when you see a reference like this, it's either a brand or model of pedal that's well known, not an effect per se. For instance, the ProCo RAT is a classic distortion pedal; you'll see people describe lots of other pedals with phrases like "it's their take on the RAT," meaning it's a distortion in the same style.
Off the top of my head, and I'm nowhere near an expert -
Preamp/EQ/DI - the core of my board is some version of this. I'm sure you know what EQ is, like on your amp. Just a pedal to put control at my feet instead of turning back to the amp on stage to tweak. Most preamp pedals have a DI these days, which is handy when I want to go ampless or as a backup if something is screwy with my amp.
Distortion - in flavors from overdrive to fuzz. Induces clipping in the signal in controlled ways.
Compression - volume control. Evens out your signal strength by reducing it by a given ratio when it spikes above a threshold you set. A limiter is a compressor that simply puts a ceiling on maximum volume and cuts off anything above that.
Modulation effects (chorus, flanger, phaser) - splits the signal and then detunes or otherwise modifies some of the streams from each other, producing swooping and swooshing sounds.
Filters/Envelope Filters - Kind of like an auto-EQ, often with a time function to adjust how the filtered-out frequencies are allowed through over time. A straight high-pass-filter, for instance, just cuts low frequencies and lets higher ones pass, so you're less likely to sound boomy. An envelope filter kind of opens and closes the gate, so to speak, giving bubbly and squonky sounds.
Reverb/delay - makes it sound like you're playing in an echoey room. Reverb tends to be just when the note holds over longer, delay is when you can hear it actually bounce back separately after playing it.
Octave/pitch shifter - takes the note you play and changes it to a different pitch. The most common and simplest is to make it an octave down, or more rarely an octave up. Pitch shifters can change it to any note you want, e.g. a 5th up or a minor 7th down or whatever.
There are also synth pedals where your bass largely becomes the controller, like a keyboard, and it makes whatever sound you programmed it to make.
There are probably some others I left out, but that's most of the common ones.