I dont hate gated content but i dont like it either. for people that have less free time than me, i can totally get why they despise it.
i agree red alerts are more or less ok, as they can be found fairly easily and does bring the community together to try and find them. I enjoyed the borg red alerts as they are not that hard to find, the random element is cool and they are quite fun. more of them works for me.
some missions do work better as gated content because of the way they are designed but id rather they just did not design them to work that way in the first place. or go with the tried and tested daily wrapper, so its still one every 10 or 20 hours but people can pick and choose when that 10 or 20 hours is.
i still stand by the idea of having missions 24/7 and then gating the double rewards to certain times. that to me does the job of not annoying people and encouraging people to aim for certain times.
the plus side of gated content is when the calendar is full and they have all the events they want, then it probably wont feel quite so bad and may even start to become enjoyable because there will be lots of cool missions to play as long as the times rotate around, so if they continue with it i dont think it will feel as bad in 6 months or a years time. at the moment the calendar is a little fluff heavy.
It can be used for flavor effects like day/night transitions or flavor NPCs who cycle by time of day or stories that play out in the bars. It can be used for timed extra bonuses on events. It could be used for a daily mission reset instead of the awkward 19 hour cooldown.