When I first saw this topic I thought it was about keyboard and mouse vs. controllers in Zelda Classic for some reason. In general I actually prefer to play with a controller, I just feel like I've got a lot more control both over the game and my choice of positions to sit in, if that makes any sense. I mean, you can't exactly use a mouse and keyboard and still sit back with your feet on the table. Unless you've got a really fancy setup and I'm sorry but I'm not ready to make my room look like a space ship just yet.
I will say though, if I'm playing a game with a first person perspective, be it Battlefield or Fallout, I'll go with the mouse and keyboard. It's about precision, but there's also something to the way you look around, I feel like moving the mouse is a little bit closer to moving your actual head than pushing an analog stick in a certain direction. These kinds of games usually also have a lot of different kinds of keyboard shortcuts and a vast amount of keys used for controls in general, so it's impossible to truly map it all out for a controller. Especially if you mod games like Fallout, you're gonna end up running into some mod that doesn't support a controller at one point. And you're gonna want that mod. I'm looking at you, Project Nevada.
I play all third person games with a controller. They're usually made for a console anyway, so it just works better I feel. Walking around and stuff often looks a bit more jarring with a keyboard and mouse, simply because you don't adjust your speed depending on how far in you've pushed a key, compared to a controller where it actually varies depending on how far you've pushed the analog stick. With a mouse and keyboard it simply doesn't look as smooth, and hey, it's a really minor detail that shouldn't matter, but it bothers me and I've got a controller and no excuse not to use it.
Also, there's a reason I'm not even talking about strategy games and so on. I don't have to, right? Because I mean, we all agree on that. We have to. Right? RIGHT?!
@Migokalle
The 6 axis controls can be mapped out using a 3rd party tool DS3, but won't work if the game explicitly doesn't support ps3 or standard pc controller. (like skyrim), but will act as a PC controller. I mapped out the controls with dolphin and I mapped out some of the six axis to motion controls and the right analog sitck to motion controls, theres a tuturial on this
My bad on the xbox360 thing, I kinda forgot what it's peripheral was used for
What I meant is that the sixaxis motion control features does not work by default, but yeah, like you said you will need custom drivers for the PS3-controller to be recognized by Windows. Back when I was using one of those, I found that just setting it to emulate a 360-controller in the the DS3-settings would ensure compatibility with all games, though of course that would limit you to what a 360-controller could do.