Re;squiddo: Berserk is also one of the most popular and influential manga ever, while Homestuck is a niche property in a medium that's widely considered "for nerds" even by other nerds. VN-to-anime adaptations can be uniquely damaging because a lot of people simply Will Not Read The Visual Novel.

By my reckoning, a worst-case scenario would be an adaptation that's not so obviously bad that it repels people on a surface level and gets the fandom going There Is No Tsukihime Anime about it, but that's bad enough that people who get into the series through the anime end up walking away with dumb takes that would be completely avoided in a better adaptation. I'd consider Ufotable's Fate/stay night adaptations a useful reference here: they sandblast Shirou and Sakura's characterizations to an absurd degree and literally cut Illya's role entirely, but they have slick enough animation and good enough PR that outsiders to the fandom still think they're decent adaptations, watch them instead of reading the VN (even skipping the Saber route because Ufotable didn't bother adapting it), and come away thinking Shirou is a bland self-insert (he's not) and wondering things that are literally spelled outright if they would just listen to Shirou talk.

A best-case scenario would obviously be a high-quality adaptation, but given Homestuck's structure I hesitate to speculate on what would even make an adaptation good to begin with. I've personally always held that if you want a Homestuck anime to be good you should probably give it to Akiyuki Shinbo/SHAFT because the Monogatari series is basically in the same boat (sitting-and-talking-centric prose with a heavy emphasis on internal monologues adapted to the screen creatively) and it's generally agreed they knocked those out of the park.