FPSes are all over the spectrum for me, in terms of interest/non-interest and I don't think it has to do with whether it's on the consoles or PC.
I've played Halo on the PC just because of the hype behind Halo (and I'll probably play Halo 2 on the PC once Windows Vista comes out). But just to see what the hype was about (and was a little disappointed, but at least I'm allowed to criticize it.
I've played Doom 3 because of my nostalgia with the original Doom.
I've played most James Bond 007 games, and they're okay. Nothing seems to touch GoldenEye in terms of fun, though.
I'm interested in Half-Life (2) because of all the physics and stuff, but haven't actually played it yet.
I enjoyed TimeSplitters: Future Perfect a lot more than I thought I would, and my brother loved the ability to create stages - despite the fact that he generally doesn't like FPSes...
Metroid Prime, if you call it an FPS despite Nintendo's insistence that it's an FPA, is cool.
But generally, if it's another one of those WWII games (other than the original Wolfenstein 3-D), or another one of those squad-based counter-terrorism things, if it's anything realistic or generic, I'm turned right off.
But yes, the Wii controller should hopefully turn the genre all around, and then all those people that need their "mature" games will turn to the Wii. After dispatching some Yakuza with the Wii controller as a sword and a gun in Red Steel, it will feel pretty lame to just push a button while aiming with analogue sticks in Halo 3. I tried it at E3, and despite being overly sensitive as a gun and seemingly undersensitive as a sword, it was still more natural, and I already felt that FPSes would be awkward to play the "old" way, whether with analogue sticks or a mouse.