I for one enjoyed FFXVI. Not the best FF sure, but for me it was the best since X (If we are not counting XIV).
As for Yoshi himself, I like him, he has done good things and his mindset seem more clear and ethical then a lot of big name people in the gaming industry. That said, I do always think people put him on too high of a pedestal after ARR. No producer, creative etc is gonna be perfect, they are gonna fail and do things one dislikes. Its human, and in the end he is there to make SE money. I see nothing about Dawntrail that would make me think any less of him, but we shall see.
Normra is... I love him and find myself fustrated by him haha. Not sure I would like to se ehim take over XIV. You know who I would? Yoko Taro. Yes, I liked the raids!