There are still hundred-hour adventure games and RPGs created today, just not very many. Personally, the trend I keep finding annoying is the trend towards making a few of the things needed for "100%" require either some other hardware/platform/console/game, some multiplayer/online activity, or some mindless pervasive collection with no in-game benefit (especially if it requires some of the previous things; I'm looking at you, Wind Waker photos/statues). I used to go for 100% in every game; I don't anymore.