They wrote him a bit too hammy in a lot of episodes. But I rather enjoyed the whole humanity on trial storyline in the pilot and series finale. I thought perhaps that story line continued would have made a more appropriate 1st movie than Generations. The metaphysics in that would have made for a more compelling movie for me.
Dude holy shit yes!!
At the end of AGT, we basically get Q saying "yeah that was just a taste of what's to come!"
Perfect for a Q induced adventure with Kirk, Picard, and both crews. Something to really test humanity, not with the silly games, but a real test!