This is becoming one of those like "9mm or .45?"
Q: Tritium?
A: Yes, for sure. Unless you don't want to then just don't.
I shoot in low light and night a lot. Own lots of night vision, but have done plenty of rifle and handgun shooting without NODs, in white light, or no light. Partly because I started in the "what's a NOD" era, and spent lots of time in the not-everyone-has-night-vision era. Have trained a bit in it (student and instructor). I (therefore) have tritium on most of my handguns AND rifles.
I went through a period of trying fiber, bright paints, da-glow plastics even. Meh. Didn't work in all conditions, so aside from not that bright, the variability messed with me. I am back to very black with tritium. I am far side of the Yes To Tritium campaign, so even get bare tritium tubes to update old sights, install in hard-to-illuminate guns. Do it for friends also.
All my EDC guns (and serious rifles) have RDS and WML as well as tritium. Backups, finding them and indexing before you get fully up to the eyeline, odd lighting conditions, etc. Odd lighting is more often than not the norm; not getting people who think they will be able to shoot in their house and just flip on the lights. Power outages? Bad guys with flashlights?
Anyway, useful enough, never regretted it having tritium and it doesn't make me poor. Remotely careful shopping will get you tritium for only a few bucks more than quality irons. Sometimes I have gotten tritium cheaper than non!