Earth Defense Force 4 or 5 can be good “training” games. They’re 3rd person shooters, you’ll spend more time moving around than aiming, since your targets will be giant insects, giant spiders, giant aliens and giant alien ships. Even playing online with randos is fine and fun, and I say that as a similar 30+ yo dude.
It’s a grindy game tho and, much like Dynasty Warriors, you should NOT let your pride dictate that you should “start with hard”. Go with medium and, if shit gets too hard, drop down to easy, get better weapons and more health, then come back with a vengeance