I like those too, in particular Dune and the Chronicles of Riddick, but they all have audience scores above 60% (and Stargate and Dune are from the last millennium if we’re sticking to that requirement).
Reign of Fire only has a 42% (Critics), 49% (Audience) rating on RT, but I enjoyed it quite a bit. The visuals and sets create a nice moody post-apocalyptic vibe, and the actors deliver decent performances imo.