I have to follow Bret’s advice myself, as I don’t know Motion yet.
However, if you look at the existing text animations in FCPX, you have a lot of options. And, when you see something you like you can tweak it A LOT to make it unique. You can change font, size, position, how it zooms in, how it zooms out, etc. Highlight the title’s box in the bottom browser and look at all the settings options you have for each animation.
I do like the one you showed in Casey’s video. I don’t think I’ve seen one like that in FCPX, but that is what he uses for editing.