I don't understand why they can't offer a manual trans, with a car like this.

There are other cars in the same class that offer a manual transmission. If I had the money, the trans selection would not deter me from buying one. Usually, people who complain about the transmission will never have the funds to buy one anyways.