Holy shit, I didn't even realize somebody already shared it on F95, thanks for that information! I wanted to wait until the weekend before dropping it there but I guess it was kind of naive of me to think nobody else would do it in the meantime... I will address everything about what's going on in that thread once I'm home from work.
To come back to your question: It definitely will be a harem'ish game. I'm not saying there won't be any consequences at all for fucking everybody you want, but you will be able to start sexual relations with (almost) every female you'll encounter in that game. Regarding fetishes / NTR: Any NTR content that should make it into the game will be completely optional, will have no effect on the main story and the player will get warned about it / can avoid it completely without any negative consequences. Furthermore, I'm not planning on making this game being centered around different kinds of fetishes. I know that there are many different tastes and preferences out there, but I definitely won't be able to satisfy all of them. What I can say for sure is that there won't be any futa/gay/gore/beastiality content. If I should change my mind on that, I will definitely let everybody know in advance.
To your last question, dominance points can be used to unlock certain scenes. Dominance is a global and character-independent stat, meaning getting dominance points by talking, for example, to the delivery guy like an asshole, will increase your dominance stat for all other characters too. In contrast to that, the "Affection" score will vary depending on the character you're interacting with. The fact that you can also earn/lose affection towards Andy (the delivery guy) doesn't necessarily mean that you will be able to start a romantic relationship with him, it just means that you will or will not have certain other options in the future, depending on the current affection score.
Hope that answered at least some of your questions but feel free to ask me anything else you'd like to know in case there's any further clarification needed.