I don't think he chooses great work at all personally but that doesn't mean he isn't very particular about who/when/what he works on, especially in recent years, so I doubt it was just all about money. He has to want to do it for some reason.
As for him always saying no to Ghostbusters 3, he said no to a major staring…