Is it wrong to love crazy over-the-type adventures like DAD but also to love serious character-driven stories like CR? And to not care for most of the Connery films and yet still consider him to be the best Bond?
I'm confused :/
No, its not at all wrong. I like both the fantasy tales if you like of Bond in the more OTT/Comedic Moore era, as well as FRWL and CR. Both are equally enjoyable. And I take that point, that DAD is a OTT adventure and CR a more grittier watch, and it is possible(for some) to enjoy both.
I personally would not enjoy DAD over some of the classic Connery films like Thunderball, FRWL etc.. but thats personal taste. I would always put the Connery films in first.
I find I have about 10 Bond films that get regulary played, the rest I can watch every couple of years or so. DAD is one I can watch every 3 or 4 years or so

I can understand why some people like it though, as I like Moonraker and some of Rogers OTT adventures, DAD is in the same league of just a fun romp.
Its the great thing about the films, the diversity of the adventures.