We might mostly run into the wild eyed cultists, but there must be a slew of stevedores and clerks who go home after a long day at work, and say a little prayer at the altar of Bane before supper.
I would like there to be more nuance in the religions for sure, and hopefully, SH is an example of that, but we'll see. It seems like the DND gods are just very binary, at least from the little I know, so nuance isn't something they deal with a lot. A more realistic religion would have varying interpretations of their god's teachings, and it'd be interesting to see a group of Shar worshippers who weren't just mustache twirling evil cultists.