civ 4 with mods is much better than current civ6. However, civ6 has, theoretically, more potential due to just more stuff like civics/eurekas/districts.
Civ 6 also has limitations though which civ 4 did not have: the user interface, very demanding pc specs for late game on big maps, obviously...