I have never used any kind of a terminator, and I can't think of an application where I think one would be beneficial, other than perhaps on the ch3/4 analog I/O ports of a SD receiver. But I sure wouldn't use a terminator on the LNB input side. As mentioned above, if you did use a terminator, I sure wouldn't use one which had a 75 ohm resistive load, because some receivers can only supply around 0.4 to 0.5 amps, and just one 75 ohm terminator would use about half of this, and if you have a motor connected, then you're over the current max of the receiver.
There are some reasons you might want a 75 ohm impedance for the RF, but since these are not weak signal situations we're dealing with here, the problems with the DC current far outweigh any benefit you'd get out of the rf impedance matching. The LNB port is expecting a 75 ohm impedance, but it's not expecting that to be a resistive impedance.
If you're considering putting terminators on a splitter used to connect multiple receivers, I would never use such a splitter without DC blocks anyway, so the 75 ohm resistor isn't really doing much except perhaps sucking up some fraction of the rf signal coming from the LNB.
If you're considering putting terminators on a diseqC switch, again, the DC problem comes up, because if you ever tune in a transponder that isn't on, many/most receivers upon losing signal will attempt to try other diseqC ports and bump the motor position to find signal, and if it hits on one terminated via 75 ohm resistance, you've got the .24 amps from the terminator plus perhaps .35 amps from your motor, and you're up over the current max of your receiver.
If I were going to use a terminator, I think I'd clip off the center conductor, and just use the terminator as a weather cap to keep out moisture. The moisture thing is a real issue with diseqC switches, as the ones I've looked at, are open to the inside via the coax connectors, ie you can stick a wire through all the way to the circuit inside, so it is a good idea to weatherproof the unused ports. But I really can't think of any good reason to use a 75 ohm terminator, particularly not a resistive load.
But this is just my mainly intuitive opinion. I've never really tried one.