I haven’t played rise of nations but from your description, you might like the core paradox games (crusader kings -> europa universallis-> victoria -> hearts of iron) despite their shitty dlc model. Currently, eu4 is on sale with all its dlc for ~£40, dlc isn’t very necessary for the other games. They are more grand strategy than 4x. You can use mods to convert saves and carry your campaign through the games. All together, they can cover all of human history (European, North African and West Asian medieval history and then the rest of the world from 1444 onwards). If what you like about rts is the unit micromanagement, you might want to go with victoria 2 rather than victoria 3, you will need victoria 2 dlc and it is a lot older.

If you want a 4x rts, stellaris is very good, but it isn’t based on human history.