Yes, I had always hoped there was a special bonus for joining the cult, but it is a waste of time. 1) It costs money, 2) One misses a great opportunity to gain a lot of experience points, and 3) the Naga will still try to kill anyone who approaches her (i.e. it is NOT EVEN an easier way to gain the snakeskin trait).