I've always been particularly interested in visuals (primarily game art) and even though I pass myself off as a programmer, creating art assets hasn't really been a big problem for me (I'm just incredibly lazy when it comes to creating asset after asset). Some years ago now I started making games and quickly realised like you, that I would need art for my games. I wasn't satisfied with using other peoples art so I opened up paint and began teaching myself how to create pixel art, worked well for me and over the years I did get somewhat decent at it (at least past the "programmer art" category) so I suggest you start there, if your pixel pushing gets a little more serious and paint is no longer sufficient, id recommend GraphicsGale (free version is good enough).
I also do some 3D work in my spare time while I day dream about one day creating that game I've always wanted to make but unfortunately don't have the skills/experience to create yet (however, I shall persevere). Blender3D seems to be the go to free solution for that, I however have a student license for 3Ds Max and Maya.

EDIT: Oh and yeah, I wouldn't recommend Photoshop for Pixel art, its overkill and can be somewhat difficult on a per pixel level (it wasnt designed for it).. Though if its texturing your doing, go for it! PaintToolSAI is what I use in that department which is pretty cool too though lacking in some areas outside of painting/drawing.

I've always been particularly interested in visuals (primarily game art) and even though I pass myself off as a programmer, creating art assets hasn't really been a big problem for me (I'm just incredibly lazy when it comes to creating asset after asset). Some years ago now I started making games and quickly realised like you, that I would need art for my games. I wasn't satisfied with using other peoples art so I opened up paint and began teaching myself how to create pixel art, worked well for me and over the years I did get somewhat decent at it (at least past the "programmer art" category) so I suggest you start there, if your pixel pushing gets a little more serious and paint is no longer sufficient, id recommend GraphicsGale (free version is good enough).
I also do some 3D work in my spare time while I day dream about one day creating that game I've always wanted to make but unfortunately don't have the skills/experience to create yet (however, I shall persevere). Blender3D seems to be the go to free solution for that, I however have a student license for 3Ds Max and Maya.