This entirely depends on what kind of game you are making and the style you are going for. You could make a game which has nothing that really tiles, everything blocky. Or something with a lot of transitions.
Also depending on your perspective and how you set up your rooms/levels you will need different corner tiles and so on.
This really is mostly a common sense kinda issue, imo. Make some mockups, see what you need, go from there.