When does it make sense to use straight weight oil (SAE 30) versus a multigrade oil (5W-30)?

Better than it has to be^®. . . Since 1903

There is no general rule of thumb for this. Follow the OEM guidelines on recommended oil to use.