Outline:
You can find some general tips about using Photoshop brushes under Retouching.
I recommend familiarizing yourself with the "Brush Settings" panel in Photoshop. You'll be able to adjust the brush to exactly what you need for a given panel.
(Updated June 2024)
Illustrator Kyle Webster used to release excellent free Photoshop brushes, but they were acquired by Adobe. You can access them as a Creative Cloud subscriber over here: https://www.adobe.com/products/photoshop/brushes.html
He also has some more free brushes on his shop here: https://kyletwebster.gumroad.com/
I maintain a free pack of brushes in my shop that are tailor-made for retouching manga. I use them all the time, and their settings are optimized for working with bitmap files.
One thing to note about CSP brushes is that some brushes are designed for specific colors spaces, and will have wildly different effects depending on the color space. The description should give you guidance, but keep in mind that most of the Clip Studio website is machine translated, so it might not be very reliable.
To install CSP Brushes (*):
Download on the brush pack's pageData Transfers button in the top right corner (looks like two horizontal overlapping arrows) to monitor the downloadMaterials panel by navigating to Window > Material > Material: All materialsMaterials panel, select Downloaded Materials to filter out the non-downloaded assets
P)Materials panel into the Pen tool's panel. (*) These instructions are for free brushes. Clip Studio has different store currencies you can use to "buy" assets. You'll need to search for an up-to-date guide on those if you need help.
Artists often just use default brushes and mess with the brush settings, so it's worthwhile to familiarize yourself with the defaults.
In addition to fonts and guides, Blambot also releases brushes for Illustrator. This might not be as useful for manga lettering, but they're excellent and worth mentioning: https://blambot.com/collections/all-brushes