I suppose I'd do it rather than go on welfare. I'm lucky enough to get to choose right now. I guess that's why I don't in any way judge some LDS person who does beer ads. Some of those members have tremendous testimonies in spite of the environment they work in. You must be able to separate work from your personal life.
Some people are able to do that better than others.
I don't think there are any blanket statements that can be made about what to work on versus what not to work on. There are plenty of quality projects. My experience has been that a certain genre film leads to more of the same genre. My experience also has been that Hollywood will try and pigeon-hole you into a category. I've been on a couple of movies where the script called for the actor to take the Lord's name in vain.