Anyway, this sort of playing is new to me. What advice would you give to someone looking to just dabble a bit in it, maybe for some moments here and there in original music?
Essential pieces of gear or techniques?
Welcome @Cristo . If you want our comments on specific gear, you will find those with a search of the thread. (most of the 1100 pages is us talking to one another.)
@monsterthompson really covered it. But for your specific use case--"here and there in original music" where you're otherwise (presumably?) fulfilling some kind of bass role, you need a way to get in and get out, and to do so gracefully. So it's not just adding pedals to your board, but a way to turn them on and off with a single stroke, if we're talking about eg the breakdown in a song. You want your delays and reverbs to have spillover so you can go back to playing bass while your textures ring out, etc. You also don't need all that stuff.
For instance, you want to enter a song from a wash of sound. You need:
a way to sustain your sound:
could just be a reverb or delay. Or it could be a Superego pedal in front of the reverb. Or it could be a fuzz or a distortion, maybe also into the delay or verb.
a way to shape the sound:
could be subtractive EQ or a tone control in the delay or reverb; could be tone controls on a distortion or fuzz; could be an EQ pedal; could be a filter
a way to get in and get out:
if you're using a multifx pedal, it could be a "scene"
if you're using a single pedal, that's really easy
if you're using a bunch of pedals, you need a loop switcher or some other graceful way to to. Or tap dancing.
Don't under estimate utilities like routing and volume pedals.
And don't forget that what sounds good at home may not sound great with your bandmates. I find gnarlier fuzz works better in a band setting than by myself; delays work more often than reverbs when I'm playing lows, and cleaner delays are more effective than the cool sounding vintagey ones.
At home by myself, anything goes.