When I saw what the full suite of FEA modules in Catia V5 could do, it blew my socks off! As for multiple load cases, I've seen guys use macros to extract load and moment data at many points from in-house beam models for hundreds of cases and put these into a design table, catia then duly reads the design table and runs all the cases automatically. The designer (with an FEA man sat alongside him!) was then able to run several design iterations on a large complex design and optimise his structure accordingly, all within an afternoon!
Like any other FE software you can (and should always) use tet10 elements. The only limitation on constraints and loading is the knowledge and experience of the guy driving the program, this is where a good understanding of free body diagrams and how to correctly apply BC's to a FE model is essential, otherwise you get the "every component I ever model is a cantilever" approach!
For optimising designs where a linear static analysis is adequate, then GPS (+EST, FMD, FMS and other modules) is probably the most advanced and powerful cad embedded FEA system available and dare I say it superior to many standalone FE systems. Unfortunately it comes at a price.