I mean.... Papyrus font worked for James Cameron's Avatar.... 
Joking aside, most covers use pre-made fonts, but they're rarely the basic fonts that come with your computer like Arial, Papyrus, Comic Sans, Times New Roman or Impact. These fonts either weren't made for professional design, or even if they originally were, they're so overused now as to lack a unique identity.
Hand-written text is also an option, but you'll need somebody who knows what they're doing. I did my series logotype by hand, but I have some design training and my partner is a designer, so I knew how to render it out as vectors and what to look for. If you don't have this expertise, either hire somebody who does, or stick to a pre-made font.
For a beginner, I recommend grabbing a font from the "Display" category of Google fonts.
Pick something that's only a little bit fancy, not something ridiculously fancy and silly. Also make sure the theme and style fits your story, for example, a serif font looks better for old-fashioned settings and Fantasy, while sans serif looks better for modern and futuristic, and handwritten tends to suit softer and more whimsical stories like Romance etc. Look at works with a similar sort of setting, genre and tone for inspiration.