My cousin and I used to play pokemon stadium for the n64 ... we should create a full on topic on that soon. It wasn't my cup of tea at the time but it still was enjoyable.
I did like me some Pokemon Stadium, that was a good time. Even figured out how to program my GameShark to make me have infinite health sometimes haha.
Never really got into Pokemon Snap, I played it but it was a little slow to me and I didn't really find pictures to be that rewarding.
Pokemon Red will always have a special place in my heart because that was really the first one I ever played. I think it was on Gameboy Color or Gameboy Advanced. IIRC, I also used a Gameboy GameShark to give myself infinite Master Balls and I would go around capturing other trainers' pokemon (in later games I think they took away that ability but I'm pretty sure you could do it in Red and Blue).
I bought Pokemon Sun for my 3DS a while ago and that's been pretty fun too.