Lugia's a pretty good generalist with Dragon Tail/Sky Attack and has good bulk to top it off. Giving it hydro pump also makes it decent against a fair share of the great league meta.
It's claim to fame is having Dragon Tail and being a good generalist while not being a dragon, which makes it a very good anti-dragon mon, since sky attack hits dragons for neutral.
Lugia, like many of the top mons in the great league, does have glaring weaknesses to ice and electric attacks though. Against the top ice/electric attackers, Azumarill and Magneton (respectively), lugia has horrible match-ups. It also looses to umbreon & metagross, but that's not a make/break factor, especially considering how well lugia does against the rest of the great league meta.
Dragon Tail/Sky Attack lugia is probably pretty good for great league, but he needs hydro pump as a second attack to really shine, and that's a pretty hefty investment.
I guess to answer your question: Yeah, lugia should be pretty good in the great league, but is he worth the investment to you?