He's fine for normal games, but he's not that great for ranked unless you're absolutely positive Azir can work with your team comp and can't get countered too hard by anyone on the enemy team. You still get kinda shit on though even against picks you supposedly counter because your early game is utter garbage, and his damage doesn't even remotely compare to the damage of every other midlaner in the meta right now until at least lvl 11. So you are out-damaged and out-ranged by most champions people are playing right now, and people will love to camp your lane because they assume Azir is a free lane (which it usually is unfortunately).
I just think he needs SOME damage given back to him, or greater range on his garbage Q. The Q nerf is starting to really frustrate me, because Azir needs it for more than just repositioning. It's a huge part of his poke (actually it's his only real poke), and it's outdamaged and out-ranged by most other midlaners' Q abilities (pretty sad that Ahri's Q is actually longer than yours, I guess they're considering the pierce through range of the spears, except they nerfed that too, so...). Without the reliability of his poke it's incredibly difficult to actually get targets low enough to safely engage them with your full combo. If you engage too soon you die - plain and simple. They need to give him a little bit more burst simply so that he can compete with the other popular midlaners right now, because you can entirely forget about doing well in lane against Leblanc, Zed, or even Annie, who can literally zone you for whole minutes because her stun is an easy way for her to drop you to half health (literally, if someone sneezes on you you basically die), and your range/dmg is actually not even impressive enough to keep her at bay. And that's just Annie.
Doesn't really make sense to me how Riot bends ass backwards to make a champion like Cassiopeia broken beyond broken, with huge damage at lvl 3 on, great sustain, and incredible scaling, but Azir just gets nerfed to shit because "late game hyper carries can't also be lane bullies." I guess unless you're Cassiopeia... Doesn't help that his soldiers still bug out every game and your wall never goes in the direction you actually point it. Bravo, Rito.