I think for the purpose of this discussion the OP meant "reverb" as an effect; something to be put on during mixing artificially with a hardware or plugin reverb device.
Since I'm the OP...

...yes, during mixdown, but not necessarily just as an "effect"...but more so to create the final “room” for your "band"….and I like mixing some things from that perspective…a band, playing in a room. I actually think that when you leave stuff 100% dry…THAT is more of an effect, since few sounds in nature exist as 100% dry. That’s something that’s been created in the recording/production environment, and is found more in later/modern production techniques.
To me, adding reverb to bass in either a DI or miked form is just not a good idea. I'm sure there are some brave experimentors out there who do it and some examples that may show it can work. But as a rule and for most practical recordings, it just ain't cool.
I don't think this can be made as any blanket "rule"...which some folks seem to be doing and follow religiously.

It's like the "rule" about always putting the bass and/or kick/snare dead center in the mix!
I never do that either, and prefer to pan the bass, kick and snare off-center by little bit. I like to put the bass and kick on opposite sides…not by much… 10:30-11:30<--->12:30-1:30 …but it opens up a nice space for the vox/lead instruments. Like if you have a baritone vocalist, or even some lead instruments that hit in the lower registers…IMO…having the bass/kick/snare dead-center, will interfere with them.
Again...with any of this stuff, it's often about the
amount you use in your particular application…and AFA the reverb, it’s also about the
type of reverb used and how it works with the song.
But it appears to me from some comments made by people who are objecting to using ANY reverb on bass or kick, that they are imagining what is being implied is the use of some Large Hall or Cathedral type of reverb, cranked up to super-wet in the same way you might do for lead guitar or vocals or whatever!

But no…not at all…it’s a very subtle application…though it does sound different from leaving it 100% dry.
Simulated reverb is used on just about everything else during mixdown...using it on kick or bass is no different, you just have to do it sparingly/carefully, but of course, a mic on a cab, in a room, might be the better way…but again, not as any “rule”.
Unless you have the right room and can really get that good room sound from your mic position while at the same time thinking well ahead how that room sound will fit in with your mix in the end…
…it just might be actually better to save the “room” application for the mix stage, even if it is simulated.
Though I agree that close miking a bass cab will probably NOT reveal a whole lot of room sound anyway.