As few genres and types of games within those genres I prefer, I feel I've already limited my choices quite a bit. So I don't get too nit picky on things like campaign length. It's not that it doesn't bother me if a game is shorter than I'd prefer, but in cases like NFS The Run, I feel I'd have missed a pretty good game had I passed on it for being short.
That said, I find it hard to go back to grindy RPGs sometimes. Even ones I enjoy like AC Origins. It's just a lot of time to spend just to get to the point where you feel you can progress without dying a lot. The kind of grinding I despise most is the idiotic crap Ubi came up with when they made The Division. OMG the ridiculous amount of hours spent trying to find gear sets, then tweaking it with special powers. It doesn't even fit in a tactical shooter type game either IMO. It's better left to games with mages. Skyrim though I got into, because you could literally play it any way you want. I never once used mage powers in that game, yet beat it on Master level. Even Skyrim became too laborious for me though. I DLed a bunch of mods I had planned to play it with, but never got around to it.
As to your other questions, never been into trophies or achievements. To me they usually translate to "Meaningless filler devs throw into games to trick you into thinking you're getting more content". It's not merely about hours played or screenshots either. The meat of a good game to me is, 1. how well the AI is made, 2, how good an upgrade system for gear and weapons it has, 3, how good a story it has, and how well it's told, 4, how challenging it is, and whether each harder mode does something more than just make enemies take more damage. 5, Last but not least is good level design, including having items you can find that are useful.
So the thing for me is not how much time, but how much quality time, and un-repetitious time. A lot of time if it's too grindy and repetitious becomes more of a negative than a positive IMO. Same with trophies and achievements, if they are too easy to get and have no useful reward for getting them, they're a mere placebo.
The thing is, it doesn't have to be a super elaborate game to offer real good gameplay. The Evil Within, for instance, is one of the best survival horror games because it has sophisticated AI that are easily alerted by sight or sound of player, and even your lantern light if they don't actually see you. They will run to the last place they heard you running. They will look left and right when stopped, making it harder to sneak up behind them. They aren't always dead when dropped, and will melee you while prone at times. This means you have to get to know the game well to know whether you're wasting those matches that finish them off when prone. There's also the right and wrong way to approach them when prone, from the head when face up, and from the foot when face down. Otherwise you risk getting hacked. I also loved how the harder modes had faster, more aggressive enemies, and wall mines that were much harder to disarm for resources. Sadly though, most players don't appreciate such features enough to take the time to learn how to deal with them, which is why The Evil Within 2 was made with zombies that only react to direct sight of you. They run a short distance, then turn around a leave if they don't see you. They even put in a ridiculous cover system, from which you can do auto takedowns by just pressing a key when they're close.
Another great game was Ghost Recon Wildlands, it had a huge and very accurate map to the type of terrain Bolivia has. Ubi sold out to turning Ghost Recon into a tiered loot sci fi shooter though, complete with a fictitious setting and an enemy with a drone army.
Spec Ops The Line was another great game, with a very gripping story that was told in a unique way, by making the player feel guilty for the violence being taken part in. It was also very challenging to play on the hardest mode. You not only had to plan what weapons to carry carefully, as they carried over into the next level, but you also had to watch out for your 2 squad mates, as if they bled out after going down, you'd have to start from the last checkpoint.
Max Payne 3 is another great game. Very good story telling, level design, pretty good graphics and animations, and it's especially cool the way Max doesn't carry weapons magically like in a lot of shooters. He has actual holsters for one handed weapons, and two handed ones he always carries in his hands. This means he has to leave the big gun behind when sneaking in through a window or crawling through a tight space.
I really feel there's not a lot of great games made anymore though, especially on PC. Many of us were hopeful with the advent of the so called Next Gen consoles, that PC games would get better, since they had x86 architecture. They really haven't though.