This place used to be an ancient city in the styles one can see at the Alcazar in Sevilla but rather than "just" a palace or building the area was an entire town with garden built strategically into the slope of the mountain. Having said that the ruins don't seem as massive as it sounded like beforehand and the big importance of the site as seen in the video is not very evident.
To reach the site you need to get to the outskirts of Cordoba. The museum is at the parking lot and free for EU citizens (there was no ID check so maybe they go by accent or trust? I.e. hide your American accent and seem trustwurthy, or just fork out whatever they ask for.) Inside you watch a prerendered CGI movie about the history of the city and it's daily ongoings. It prepares you for what you are about to see up the hill, kind of.
There is a regular bus that takes you to the museum but it is not free. I guess you could walk up the hill for free but you definitely cannot drive up there in your own car. I find that a little odd because they could easily fit a parking space nearby or at least closer than where it is now.
The site itself is poorly signed. The directions of the paths are even misleading. I love the standing arches and took a lot of pictures here but the connections to what the walls used to contain is unfortunately lost without a guide. The video showed you a lot of places and trying to find them is not easy. So whereas I found the site surely had lots of value it clearly lacks in presentation and some better explanations down in the pits would be appreciated.