TBH Ive never played or watched anyone play any of these games. I cant really judge their current entertainment value. Ive seen some people discovering Remy and SOTMK hidden kiosks, but its never struck me as something Id like to do. I didnt even know about Wilderness Explorers!
They are all pretty good. But I was a cast member for a while. So, I lived there. I don't think I would do any of them if I didn't.
The Pirate Adventure in Adventureland is my favorite because it is simple, short, and uses the environment. Basically a scavenger hunt following a treasure map around adventureland. With multiple stories so it has good replay value. Plus it gives you a fastpass for Pirates.
Wilderness Explorers is nice because it takes you on a tour of the whole park and focuses on the educational side of the park in a fun engaging way. Definitely aimed at kids, but well put together. Plus it rewards your progress with stickers which made my little cousin very happy. I'd honestly say, even though it is meant for kids, that it is worth doing for adults if you plan to spend the whole day at DAK as it really encourages and helps you get engaged with the park's themes and learn a few things (even if adults would know most of it already)
Sorcerer's of the Magic Kingdom is pretty great, but way too big of a time commitment. Especially since there is already so much to do in MK. You can just do one story, but even that takes at least a half hour. It is a fun, but simple card game. Like a super super simple game, but fun. With neat animations and plot stuff. But to do the whole story takes an entire day.
Agent P is a good mix of all of these, but also the one I've done the least. Thus, I have the least to say about it.
The Easter Eggs and the Remy hunt are great fun scavenger hunts around the world showcase. Especially with a kid in your group. Or with a group of friends and you are all tipsy (but not drunk because this id a family theme park). Downside to those is you have to pay to get the sticker things to keep track of them. But you get an actual little reward thing at the end of it. So, I still say it is worth it.
Strangely, Hollywood Studios is the only park to not have something like these games. And it is the one that could use it the most.