Maybe I'm easier to please than others, or maybe REmake Remastered shocked me back to the PS1/PS2 days, but a 6 to 10 hour tightly-paced adventure/action game sounds fine to me and can still have a lot of replayability.
The reason I bring up the resident evil remaster is that it's a pretty simple game and not a very long one (most people can beat it in about three hours or less once they've played it one time) and yet I just played that game seven times in a row to get the platinum trophy because it's just so well executed, dripping with atmosphere, and the mechanics just work. And that game doesn't even have that great of a story and most the time you're just putting things together to solve puzzles, so I can only assume that if The Order's gunplay is amazing and tight, I'll love replaying it as well.
Basically, if the game works, and is well executed, I usually have fun playing through it a few times; and thus, a six-hour campaign can easily turn into about 20 hours of fun.