So it souinds to me like you want more stuff, but not too much stuff. There are a lot of modpacks that add considerably to the game, sometimes to the very extreme like C2C. (
So try Xyth's mod...haven't myself, or you might try the Realism Invictus, one of the oldest big mods for the game that is still very active an the original modder still updates it. RI adds/changes quite a bit to the game, but I think it is reasonably done. Note, that some resources are still revealed by certain techs, but most of those techs come very early, and resources like wheat, corn, pigs, cows, horses, seafood are revealed from the start. Idea behind RI is to add a bit of historical accuracy and concept to the game.
Note: A lot of the big modpacks have the hidden resource thing in the game, and I do think some take it to the extreme. But keep in mind that a lot of them have borrowed assets and concepts from each other.
I can't think of a mod that adds just a little bit to the game from an altered gameplay perspective, which it seems you want. But I think RI may be the closest thing to it. I thought one the principal ideas behind Legends of the Revolution, if I recall, was to "enhance" the game without going overboard with changes. Haven not played it in years so don't quite remember, but sounds like you already tried that mod - did you look closely at the LoR forum to see if some features could be deactivated. I think the revolt stuff comes from Revolutions DCM and that feature can usually be adjusted in the game options. Same with some other mods. And events you should be able to disable in custom game or scenario setup.
Others I've tried that may be an option are Quot Capita (which now I think it is being kept active/updated in a new iteration called Quot Capita: Majestic). It's a pretty big mod. Another you might like to try is Rhye's and Fall of Civilization (RFC). It's one of the most classic modpacks for Civ IV and is actually delivered as custom content with base BTS. However, much work as been done since and you should try the modmods like RFC: Dawn of Civilization, which is really the goto version of RFC now.
The deal with RFC is it adds very little from a base game perspective - like new units, buildings and stuff, no hidden resource junk. It's more of a history simulator played on a custom scripted world map. The big thing is the Unique Historical Victory conditions and event driven scripted map. They are actually quite fun and allow you to play some rather shorter games with some ancient civs like Egypt or Babylon or longer games with others. Civs spawn the map at or around there historical dates. Like Egypt, Babylon, China, and India are present at the 3000BC start, then civs like Greece, Rome, Persia spawn some years later in the late BCs. and so on.