The impression I get is that while a particular drug might work well for a certain type of epilepsy (say ethosuximide for absences or rufinamide for drop attacks), at least as far as drug resistant epilepsy with many seizure types, goes, evenwith consultant neurologists, its just a case of "What shall we try next? Shall we try zonisamide or rufinamide?" (And that is usually in a combination of three drugs) Then after they have been tried and we are talking about trying an 8th drug, its "What about perampanel?"
I agree that sodium valproate is one of the older drugs, which tends to be broad spectrum - ie treats different kinds of seizures, not just one type. In our experience, it caused cognitive slowing, but then many of them do, because as one consultant told us "Epilepsy is just an over-excitable brain!". I assume the function of drugs is to slow that brain down; but unfortunately, we can't be selective about what they slow down! It also caused an increase in appetite, although it does not have a magical effect of increasing calories in food - so long as you keep them on the same diet as before, they won't magically gain weight. It is also supposed possibly to increase behaviour problems - we didn't notice that particularly, but then we have found any of them can do that; and there can be aggression before or after seizures anyway.
Lamotrigine for instance either made DD hyper or depressed!
Keppra is probably more expensive, as its a newer drug. I have heard it can transform some people's lives by controlling seizures. It didn't do that for DD; and she did suffer Keppra rage! We were living on eggshells - for instance, if we asked her a simple question like what would she like for dinner, she would jump down our throats in an immediate rage. I asked for her to be taken off it, as it was no better for seizure control than sodium valproate; but much harder to live with the rage!