I use a medium Wacom Bamboo Fun and think it's pretty good (apparently the Bamboo line got renamed but not sure what the new name for this model is... it looks like this)
It's technically my second tablet, since years before that I had a tiny Wacom... however, I never got used to it and it was just too small to properly draw lines, so my current one was the first one I actually started properly using. So I'd personally recommend against small tablets (even if they're cheaper), though some people find them okay and easy to use so it's up to you (if possible, see if you can try it before you buy?)
As for programs... I draw my comics in SAI, with text from GIMP and frames from Cloudalpaca (though I might possibly switch over fully to Manga Studio now if I like it)
I love SAI, it's great for drawing, and not too expensive compared to many other art/image programs. I love how it's easy to edit and play around with brushes, and it has tons of brush settings. (Some people say it's "hard to learn" or "looks too complicated" but this is not my experience at all, it didn't take long for me at all - if anything, I consider Photoshop to have an annoying interface) Though, just a note: the biggest flaw about SAI is that it doesn't have a text tool... so if you're gonna make a comic, or just add non-drawn text to your picture, you'll have to add the text in another program. (What I do is open the picture in GIMP, adding text, then saving just the text layer and pasting that into SAI again.) SAI 2, which is currently in beta and still in development, has text, but it can only save as bmp and the program-specific format for now, and takes forever between each new release...
I also recently got Manga Studio 5/Clip Studio Paint, and while I haven't actually drawn anything more than sketches and brush tests, it seems pretty good. It also has a bunch of comic-specific tools like frames and bubbles, and features like poseable 3D models and background effects. (It's actually on sale for just 15$ currently!)
I've tried some Photoshop but never got into it, and I don't really like it for drawing (better for actual image edition)
When it coms to free stuff, I've tried Cloudalpaca/Firealpaca and GIMP. (Plus a few others, but I don't really have a lot to say about those)
Cloudalpaca (which is now known as Medibang Paint and is the same thing as Firealpaca but with extra comic features - love the frame tool!) is pretty good. Text tool is... kinda clunky and annoying (instead of just writing directly on the image, you have to write the text into a pop-up box and change all settings from there...) but at least it has a text tool.
Gimp is... decent but not great. Also, I've had a bunch of issues with my tablet in Gimp (while it works fine with any other program), and according to Google I'm not the only one. For example, it lags a lot unless I use a small window... I haven't really used it in years except to add text.