To prove your point, I will offer my own belief. Actually, I am not posting it here because it supports your observation but vice-versa, because your observation supports my point.
You're right: there are always people crawling out of the woodwork suggesting one approach or the other. Whenever someone gets evangelical about something, it proves that it's working for them, for the moment at least. How else could they think that their mundane and unoriginal approach is "the" solution that will change lives? There are evangelists for everything from walking an hour a day on a treadmill to rock climbing. Ergo, almost anything works for some people sometimes. However, no new or old exercise idea has had widespread acceptance and staying power. Therefore, every idea fails for most people, either immediately or eventually.
Conclusion: Certainly educate yourself about all the options and their benefits, but right now, do whatever you find compelling right now. Don't worry about whether it will for someone else, or whether it will work for you next week. Just do what works for you right now.
For example, I thought I was bored with kettlebells (lately I've been trying to learn Olympic lifting) but one night last week for some reason I didn't want to leave my apartment, so I did a kettlebell workout. That worked for me on that particular night. For some people, that wouldn't work at all, because they like to have every workout scientifically planned out: exercises, reps, weights, etc. Sticking to the plan is what motivates them, so they would have dealt with the situation differently.
Some people really get off on the idea of having a "treat" occasionally. For them, maybe they can motivate themselves by signing up for a triathlon in some exotic location. Or they might take a day off and visit a national park, or treat themselves to a beautiful evening wandering around with a friend, splurging on a show and a nice dinner downtown. (Two or three hours of walking may not be challenging, but health-wise, it beats the hell out of sitting at home.) Or maybe they would sign up for an expensive activity such as riding lessons.
It all depends on your situation. Do you have outdoor recreation nearby? Do you live in a walkable or bikeable city? Can you afford Crossfit or an expensive gym? Do you have a garage where you can put a few hundred dollars worth of weight equipment? Do you have enough money to become an equestrian? Do you get off on consistency, or is boredom your bane? Does measurement of your progress motivate you or demotivate you? Do you like to geek out over your fitness, or relax and let your mind wander? Do you like it if your workout activities express your trendiness or your wealth and status, or would you prefer a "no bullshit" workout at a grimy gym surrounded by tattooed guys in sweat pants?
There's no answer that fits everyone all the time. Different people will thrive with different choices, and next month you may be a different person than you are now. Just do whatever works for you right now. (If that means forcing yourself to do something you don't want to do, well, that is a paradox. Best to just do it and not think about it.)