These are what we call the 'YMMV items.' Things that some people find in this work. We call them 'your mileage might vary' because not everyone sees these things in the same way. This starts discussions in the trope lists, a thing we don't want. Please use the discussion page if you'd like to discuss any of these items.
In fact, the movie's costuming, style, and story is actually much closer to the look and feel of the Conan comic magazines (and thus the original stories) than pretty much any other Conan movie that's been made. The first Scorpion King movie did the Conan setting better than Conan did.
Funnily enough, the newConan the Barbarian movie starring Jason Momoa has drawn some criticism for being a poor man's substitute for The Scorpion King.
So Rise of a Warrior gets Randy Couture as the Big Bad for an entry in a series that is known for having some pretty awesome melee fight scenes. The final battle should be pretty cool, with him being a hell of a UFC fighter and all. So what do they do? Have his character transform into a horrendously animated giant invisible CG scorpion.
The third film has perennial Bad AssRon Perlman as the heroic king who has hired Mathyus to help him, but has a grand total of three scenes, only one of which shows him kicking any ass. Similarly, Mathyus and the film's Big Bad—who admittedly has been pretty non-action-y for most of the movie—have a climactic chariot race instead of any kind of sword fight.
Well it is a title that's very impressive and sounds scary, it's not like only one guy would have wanted it. And this is historically correct, too, as there were at least two historical people that claimed (variations) of the title Scorpion King.
It sure beats 'Ten Thousand Rabbits' as a name for a warrior king. Though the Maya apparently were impressed.