Ep 7's revelation is even more silly than Ep 6's. They end the story with a tease for Season 2, but it is archived due to weak and convenient worldbuilding, not good writing. I won't return to S2, if there is one.
I don´t mind being spoiled so I read your post but....
isn´t it kind of dumb?
I had reserved my judgment previously, but now that I've finished it, I think it's dumb. The first six episodes is good neo-noir that deal with down-to-earth topics like fame obsession and sexual assault. It implied that Sugar was dealing with some unusual issues, but a PI with a mysterious past is a genre norm. After the twist, I no longer care about the case because the narrative's focus has shifted dramatically. My emotional investment in the case is gone, as are some of the human characters, because they no longer matter. In the end, it turned into two undercooked stories that were awkwardly blended.