I tested that recently while editing a video and honestly it's become way simpler than it used to be. The auto captions function is in the "Edit" tab (not Fusion), you go to "Captions" in the top menu, and then you click on "Generate Captions" or "Auto Caption" depending on your version. It's free, yeah, it works with the free version no problem.
For French, it works great now. Before it was a pain with languages other than English, but now Resolve uses a speech recognition system that handles quite a few languages. I tested it with French and it recognizes pretty well, like maybe 80-85% accuracy depending on audio quality, so you have to fix a few words but it's far from being trash. But if you have crappy audio or really strong accents, then yeah it gets more complicated.
Once it's generated, you can edit the captions directly in the timeline, delete the stuff that's messed up, add missing stuff. The timing does itself so you don't have to mess around with timecodes. Just make sure to check your audio beforehand - if you have background noise or music drowning out the voice, it's gonna generate garbage for you.