E-2 or O-1.

What's the success rate of founders getting E-2's if they get funding from YC?

The success rate of E-2s in general is high but remember that the investment, to qualify as investment in the E-2 context, must be from citizens of the same country as the applicant so YC money and the money from any US investor is not directly relevant in the E-2 context.