I use the awesome Samaritan International (also known as AstroCity), from ComiCraft for text dialogues. It's expensive as hell ($150.00), but like @Shanny8 said, there's these really good sales at the beggining of each year. They have a huge collection of professional dialogue fonts and they all look great, but I personally liked this one more.
I have some other fonts that I bought or downloaded for free, usually from ComiCraft and Blambot. I bought on ComiCraft sales the fonts Rassum Frassum and Onomatopedia, for example. I bought Silver Age from Blambot but I didn't like the kerning that much. All the other fonts I usually get for free from Blambot to use as SFX or at the title.
My biggest issue with fonts is how Clip Studio Paint is incapable of dealing with OpenType ligatures. Fonts have a very shoddy kerning on CSP and if you need to access the special Onomatopedia characters you're out of luck. Worse, it doesn't export text layers as text layers when you convert the work in PSD, which would allow me to fix everything reasonably fast on Adobe Photoshop.