On MacOS 14.2.1, with Canon R3 and CR3 RAW files.
I don't use catalogs at all, just drag and drop raw files into Library, then edit in Develop. Just loading a directory of RAW files in this version just automatically generates XMP files for no reason, an old bug I haven't seen for many many versons.
As usual, XMP files should only be created when there are changes done to the RAW file, not just upon loading them in lightroom. It's a good system so I can edit galleries as needed, and then I can look in the directory and see if there are any photos I might have accidentally skipped over deleting by seeing there is no XMP associated with it.