Alone in the Dark: The New Nightmare has four slots to save, if I can remember correctly, and to do so you need to collect amulets throughout the game. And that is a very action based adventure game. Even they don't allow going much back and forth.
Indiana Jones and the Emperor's Tomb doesn't have a manual save option, but it saves automatically as you progress in the game.
I agree with Wormsie. Don't worry about it as long as you make the flow of the game logical and interesting.