completely botched the character, turning him into a bungling, Clouseau-type figure who was hopeless at everything and suitable only for derision.
How is that different from him on TNG? I'm no TNG expert but I do recall being bored to tears by bumbling Alexander wasting an hour of my life in the useless filler episodes "Fistful of Datas" in which he gets trapped in a holosuite program and daddy has to also waste an hour of my life performing nonsensical acts to save him.
IMO Alexander was never much of a character to being with. DS9's treatment of him just expounded on that.