It's not so much the type of memory used but the the format the camera shoots.
Looking at the camera specs, none will work directly with FCE.
You need to get a camera that shoots standard AVCHD.
eg. The JVC shoots AVCHD Lite that does not work directly.
You can transcode with third party apps but that's jumping through unnecessary hoops.
With an AVCHD camera you connect to the Mac with a USB cable with FCE open and select Log and Transfer.
Very simple with the correct camera.
BTW: FCE only works with Interlaced footage. Many new cameras are selectable between Progressive and Interlaced.