I can see why it was cancelled over the art...
From The Lost Media Wiki
The page with which this comment is associated has been deleted.
but that's not what I'm talking about. A while ago I saw someone on Twitter talk about this article and show that they have the manga and they showed an Amazon listing for it. I can't find the video but I think this is the same Amazon listing they showed there. https://www.amazon.com/Melancholy-Haruhi-Suzumiya-Kadokawa-Comics/dp/4047136581 Some guy in the review section actually provides pictures of it so you can clearly buy it from there. I guess this means the first one is fully found?