If you’re looking for the opinion of someone who is not a fan and doesn’t feel the series is for him, but has played several...
I’ve played 5 Pokemon games: Pokemon Snap, Pokemon White, Pokemon Y, Pokemon Go, and Let’s Go Pikachu. Pokemon Snap was a lot of fun. It features a character going around on-rails with a gun and shooting many Pokemon, collecting and grading those pictures you shoot. Pokemon Go is (for all intents and purposes) is over now, but I don’t think I need to explain. It was by far the biggest Pokemon game, and culturally significant.
Choosing between the other three is (mostly) irrelevant, as they’re all similar feeling games, they have almost the same story. They’re kind of like EA Sports games, where if you’ve played one, you’ve played them all, and the advancements don’t feel significant. All of them feature battles, turn based, but Let’s Go Pikachu has done away with random encounters, so encounters are all by enemies you see on the screen. Pokemon collection also differs. White and Y use the same system as Final Fantasy 8’s monster carding system, where you weaken them and then throw a ball, instead of using the card capture skill. Let’s Go uses a more active Pokeball throwing mini game. Collection is the main drive of the game, but if you’re anything like me, you’ll be tired of it after 30-40. If you care about iconic Pokemon, Let’s Go has by FAR the better Pokemon, White and Y had multiple times more Pokemon altogether, but I didn’t feel that I came across more. 150 or 700, it doesn’t really differ in my experience, just dilution of the ones you want. It’s a perfect example of how extra content doesn’t necessarily improve the game, and in some ways it takes away from it → Chrono Trigger DS, Sword of Mana, and Final Fantasy 6 Advance, I’m looking at you. But, off that tangent. Of these three I found Let's Go Pikachu to be significantly more fun and satisfying than the other two, but it's also a newer game; Pokemon Go was more of a social experience; and Pokemon Snap was probably the most fun, but it runs out of steam quickly.