Ancient-Red-Dragon: The adventure game genre is dead because most devs have no clue how to make logical puzzles, and almost no one likes playing the illogical puzzles that they do make.
Breja: It's not like they were any more logical back when the genre seemingly ruled the world. If anything, it's the opposite.
Yup. I absolutely agree. Whenever I remember the "classics" or the "greatest" point & click adventure games, there's always one or two really obnoxious and obtuse puzzles I associate with each of them. And while some of these games that are being made today do feature the occasional illogical puzzle, the tendency is to simplify things; focus more on narrative and character development and less on puzzles. I haven't been stuck in an adventure game in years, now, at least not to the point of that stupid rubber ducky puzzle in The Longest Journey, the much dreaded "kick the crack" puzzle in Full Throttle or the downright absurd (if you lived outside the US and were just a little kid with little-to-no grasp of English, like me) monkey wrench puzzle in Secret of Monkey Island -- looking at this one years later, it *is* logical... kinda, I guess. But it was still unbelievably hard for me, back in the day.
Also, most of Daedalic's more well-known games are also famous for their oftentimes extremely hard puzzles. Overall, though, I think that's it. Some exception or other amongst the Wadjet Eye catalogue, too.
I, for one, welcome the less obtuse puzzles of today. And the fact still stands that, whether you find the puzzles of today's point & clickers easy or hard (your mileage may vary, I've met a girl who thought all the puzzles in The Longest Journey were extremely logical and they all made sense to her, while she struggled with even the simplest hurdles in the first Broken Sword), it doesn't mean the genre is dead. It's far from being dead, actually; it's just not as dominant as it was in the past, but it's definitely flourishing.
[EDIT] As for RTS games... I honestly wouldn't know. I was never really into strategy games, real time or otherwise, so I guess I'm not really interested in looking for them and, thus, I don't know if they still make them today, or not. I'm under the assumption, though, that they aren't in as a healthy situation as the point & clicks seem to be.