She was an klutz but she was sweet and hot. Spilling coffee on the captain was stupid... the writers could've done something else to indicate she was "book smart" and not "street smart" without making her look like an idiot. She would've made a great Assistant Chief Engineer if they'd written her character differently and had tons of options (potential love interest of LaForge, someone to take over if LaForge were injured or incapacitated, etc.).
I still cringe whenever I watch "Q Who" and see Gomez spill the coffee on Picard. What an utterly awful scene. Rather than making me (the viewer) sympathetic to the character for being a bit klutzy, that scene made me wonder how she got through the Academy if she was always spilling hot (and potentially hazardous) liquids on her commanding officers.
I suppose, if she had stuck around, she could have made for an interesting right hand woman for Geordi, but that probably would have taken away from his interaction with Data. As for Gomez being a love interest for Geordi, I just cannot see it working in any believable fashion. Geordi dating someone under his command? No, sir.