Am I against “yes means yes” and “no means no”? Perhaps am I not enthusiastic about enthusiastic consent?

No, but I think that these paradigms can be enhanced by a broader approach to consent to better assess this “enthusiasm” and to become even more useful.