>>324466805
No, same with Contractors. Onward is a bit better but it's still not great. It all devolves to shooting at dumb bots. 
I actually can't think of a good singleplayer vrfps. If you're fine with something more janky then Zero Caliber can be fun, especially with friends (it's just PvE). Pavlov zombies is the same in that regard. Boneworks also but most think the gunplay in that is pretty ass. 
H3 is good as a gun autism simulator but there's no actual game there.