Is our opinion about Zayd ibn Imam al Sajjad positive? Also what is his story?

Yes he is praised by Imam Sadiq. He revolted against the Umayyads and he was killed. Imam Sadiq says if he was successful he would have stayed with the Ahlulbayt and he was not calling people to follow him as opposed to the Ahlulbayt.