Dice Rolls
There is input randomness and output randomness. Input randomness is resolved before a player takes an action, allowing them to decide which action to apply the result to. Output randomness is resolved after a player takes an action, altering the result of said action. Bargain Basement Bathosphere uses input randomness while final girl uses output randomness.
Input randomness can serve as gameplay variance. Wingspans birdfeeder dice alter the game state for the players to vary the decision space. Output randomness can also serve as variance, but for future actions. In fact, output randomness in general serves as input randomness for future actions.
Output random dice rolls, however, can serve as a point of tension and excitement, but to do so generally requires the results to be instantly recognizable. If results need to be adjusted or interpreted, as in a game like Dungeons and Dragons, then the excitement will be hamperred by lookups and computation. Custom dice can help players interpret results more readily. Instead of relying on the players to readjust the outcome after the fact, have them change the dice their rolling to ones with different faces, such that the results are immediately apparent.