Unfortunately Waifu and Harem trash are the mainstream... Its what the majority want and consume and it will mean that characters with actual personalities instead of being self inserts and story lines which make sense are a distant dream.
Every now and then we get a good Yuri adaptation, but those are rare and far between.