The game is a 3rd person (may develop into optional 1st person) low-poly roleplaying game.
Modelling, I have no issues with.
However the texture with said models are the problem. Im not a texture artist.
Ideally id like to go with a Runescape Old School (Ah, the good ol days) or Daggerfall (Elder Scrolls 2). Sadly both of which has elements of pixel art I do not have the patience for. (I know RS is not composed completely of pixels.)
So, what are my options in terms of easy to produce graphics? Id rather put abit more work in rather than just yellow, black, blue or grey.
One option is to render very low resolution (64x64 or 32x32) animated sequences of your 3D models and make them into sprites. This has been done in several games before. Just a suggestion to overcome your limitation in textures and pixel art creation.
OK, how would I do this? I know how to turn a texture into a sprite and that’s it
Basically - I’ve seen several tutorials online describing this workflow. I can’t remember if I ever saw a tutorial specifically to Unity with this workflow, but they are essentially the same - except the buttons you click to create a sprite animation, and the inner workings for mecanim.
Here are a couple links that should help
https://www.assetstore.unity3d.com/en/#!/content/31247
https://www.assetstore.unity3d.com/en/#!/content/15688
https://forum.unity3d.com/threads/sprite-maker-convert-3d-to-2d.232302/
https://www.youtube.com/watch?v=dfeNCUYDipg
https://vimeo.com/2737182
Note: I did not look through any of these - only googled create sprite from 3D animation.