Well, I never got into Civ5 modding as much as I did Civ4, but I've used Lua in other projects and honestly, I'd be happy with either one. Lua with Civ4's hot-swapping and robust API would be my ideal, plus C++ access on day one, of course.
What still bugs me in both Civ4 and 5, though, is XML...