Are we talking types of fantasy, or types of game theme? These are two different things.
Also, a lot depends on dm style. I myself basically use a rule system for combat, physical type stuff, with most other game elements not requiring a rule set.
But again, that is dm style more than system.