I have motion sickness issues with a lot of first-person games. I'm not sure what fraction of those games cause issues for me, as I usually avoid them now, but I've never been able to get into FPS games, and I don't care for first-person modes in games that give you the option. It's a shame to cut out whole swaths of games that a lot of people love, but I have plenty left to play that I enjoy, so it doesn't cause too many issues.
Cameras can be bad in general, but I'm usually ok so long as I'm in control of the camera, once I've gotten used to it. It can be a little rough when games start off, though. I find that depending on the game, the size of the screen, where I'm sitting, what sort of control setup I'm using, how tired I am, etc., also makes a difference.
Recently, I had some issues with Super Mario Galaxy in the 3D All-Stars collection in handheld mode. I haven't tried it in docked mode yet, but I never had issues with it when I played the original game on Wii (100%ed it on Wii, which I rarely do with my games, so I obviously wasn't in a hurry to move on from it), so I'm wondering if it's something about playing it in handheld mode on a smaller screen that's close to my face.
I've never tried VR, partially because I've been suspicious that I'll suffer from VR motion sickness. I do tend to have a lot of motion sickness issues in real life that I've never outgrown (I get motion sick on most forms of transit, and have ever since I was a kid; I also can't read, play games, or do much of anything besides stare straight out the windshield of a car if I'm a passenger). It always throws me when people can get lots of work done or game time in while traveling, as I really can't do anything besides listen to music or audiobooks, talk to my travel companions, attempt to sleep (usually unsuccessfully), or stare into space.