I disagree, I think the name is very telling of how it started out vs the way it is in the end
Kaido's devil fruit might be the actual real special case. Imo it's highly likely that the God based mythical human fruits, unlike the beasts in that category, grant the user the true God form once awakened (Yes i'm suggesting Sengoku's bhudda form his him awakened). The only thing special about Luffy's fruit is that it's true name is hidden as far as Zoan transformation goes.
The Ou Ou no Mi: Azure Dragon Fruit is the only mythical Zoan fruit that the end result doesn't match the name lol. We already have dragon fruits in this series. In which the fruit easily could have been "The Dragon Dragon Fruit: Blue Azure Dragon Model" but Oda didn't go with that.
Reason being, most likely doesn't start out as a Dragon. Oda is probably playing into Chinese mythology. After trying for 100 years, a lone koi fish through sheer strength and determination made it up a waterfall so tall that it was nearly impossible for even the best jumpers to get to the top. The gods, who recognised this feat rewarded the Fish by turning him into a Dragon. It's very likely Kaido's devil fruit was exactly that lol, a koi fish/whatever kind of fish, that he awakened into a Dragon once his mind and body was in sync with the fruit
Sengoku's fruit isn't the Buddha fruit, but a statue based on the deity, otherwise he'd be the most OP thing in this universe. But I digress. Which dragon fruit are you referring to, btw? Since the only time the term dragon in the series is being used is with the dinosaur DFs since dinosaur in japanese is Kyoryu, hence why it's abbreviated to Ryu.
And yeah I know the myth behind it but I still don't think Kaido at the start was just a fish. Since that's more or less linked with water and for the almost 20-year run of the manga we've yet, at least to my knowledge, see a DF ability that's linked or has something to do with water. Only the ice logia and or snow comes into that territory, but it's in another state, so they don't outright null other DF users. Especially zoans would be easy to give to the numerous amounts of fish in the world, but there isn't any because we already have an entire race around it.
I still believe the naming around the fruit is just Oda being fancy. I could be wrong, of course. A flashback into Kaido's past will most likely confirm which one is correct. Which we'll get sooner or later. But if the fruit's awakening is going from a simple fish into a dragon that'd be pretty lame ngl. I mean if I was Kaido and I was given a fruit that turned me into a fish I'd be like get the hell out of here Lilin and fuck this fruit you gave me.
I wouldn't bother trying to learn it. Nor getting to a point of awakening which is more or less linked to mastery the more we see it.