On the topic of specific genres on PC vs Console I'll give my personal breakdown.
Real Time Strategy - unplayable on console IMO. Even ones that find clever ways to make them more playable are simply far inferior than they would've been on PC. These types of games are designed with KB/M in mind and your speed and playability of the game is seriously hindered on a controller.
Turn Based Strategy - Playable on both. Have played X-Com on console and found it to be just as good. Since in these games you have the time to make your move and they've been optimized for use with a controller I see no real difference. I think Civ V and VI would do fine on a console.
Sim - It's just a vast term, but most of them I think would be fine on console. The obvious ones that just work no problem are farm sims (Stardew Valley), The Sims, Racing Sims (With a wheel, it's the same, without a wheel, I prefer controller vs KB/M), Building Sims (Cities Skylines) I haven't tried on console in a while, but I can't see it being too bad. Basically anything where speed doesn't become an issue like an RTS should be okay.
FPS - Vastly better on PC. Some games that have server based online use match making on console which just ruins it for me. KB/M is better to aim. Console is still playable, you're on an even playing field, I just much prefer PC.
3rd person shooter - See FPS, it's pretty similar IMO.
Obviously each genre depends on how well the devs optimize the game for one or the other, like Batman Arkham Knight could easily be better on PC where you have the choice of KB/M or controller, but it isn't due to the game being a bug ridden mess. It goes the other way too, with some games being so poorly optimized for console that they dip to single digit fps at times. (iirc this was happening with Dead Rising 3 on Xbox one)
For when I want to lay in bed and just play games console is awesome. Will never understand the whole #PCMR thing. I'm into high end PC gaming, when I build a rig I want the 1080Ti with 7700k etc. Overclock all the hardware, try to push it to its absolute limit etc. But consoles have their place too, for me graphics and performance aren't everything. Sometimes you just want to be able to lay in bed with a controller and play games. Although, having a mini-PC in my bedroom does sound like a lot of fun