I do a lot of graphics and I have done the artwork for several CDs, including one I recorded in my studio.
Here are some thoughts: Paper labels are bad. They look nice at first, but they peel off the discs and jam CD players, or get put on crooked and make the CD unbalanced, or they get wet or...lots of things happen, all of them bad. The thing I don't like is that it's really difficult to center the label. And it never looks like anything but a pasted-on paper label.
Epson makes printers that will print on ink-jet printable CDs. In other words, you have to buy CDRs that have a blank (usually white) label side that will accept ink-jet ink. I have the Epson R300, which I got for $180US. Basically you prepare the artwork with something like Photoshop and then import it into Epson's software to print the CDs. Epson says to burn the music side first, and that's the way I do it. They do an acceptable job, but it is time-consuming to calibrate the colors so that the CD looks right. For 100 CDRs, the cartridge expense starts to add up. The R300 uses 6 ink cartridges, and I get them for about $11 apiece. It is also time consuming, since you have to feed in each CDR individually. Still, this is my choice when I am burning no more than a few CDRs. The labels don't peel off, and there are no mechanical problems.
The last possibility is having the CDs replicated and printed at a plant. This is the only way you can do it that really works for more than just a few.
The bottom line is, you can get inexpensive, or easy, or good looking, but getting all three attributes without specialized equipment is not really possible. Unless you want to spend a lot of time learning how to do it, and you can do the graphics to an acceptable standard of appearance, and you can buy the printers etc to do it with, it's better to have it done.