At this point it is still unknown if all DFs will be able to unlock an awakened state. Right now we only know of Donquixote Doflamingo (Paramecia) and the Impel Down guards (Zoan). There is one more but this might still be manga-only (I haven't watched the anime in a while) so I put it at the bottom of my answer and marked it as a spoiler.
I would assume that an awakened ancient zoan DF user, like Drake-X, would still enjoy the same benefits as an awakened regular zoan DF. These benefits are increased strength and durability which also leads to a higher recovery rate. This information can also be found on the wiki, please keep in mind that this article contains spoilers so thread carefully.
There haven't been any logia devil fruits shown to have an awakened state yet.
Charlotte Katakuri has an awakened devil fruit as well but this is a paramecia DF that acts like a logia DF. The benefit he got from awakening his DF power is the same as Doffy's i.e. turning his environment into the element he can control.