In the Adobe support training video for after effects there's a demonstration of applying a 3d fly-in effect from a long list of text effects in the effects panel. I have an up to date CC installation yet only two text effect options show. Is the list in the training video a bunch of effects created and saved by the demonstrator? Have the rest moved? Are they available to download?
I really don't have time to programme in my own text effects from a zero starting point.
You probably have some filter enabled on your effects & presets palette and are mixing up effects and presets in the first place. Check the settings in the palette's flyout menu.