Is Lulu actually good in Final Fantasy X?

Yes. She feels slow early because her magic stat is low and her overdrive input is fiddly, but once she has the -ga spells and Doublecast she's one of the biggest damage dealers you have. Her Fury overdrive scales with how fast you spin the stick, so practise it. Lots of flying and elemental enemies are basically her job.