I’m working on a story which centers almost entirely around one character, and I was thinking about using her name as the title. I just wasn’t sure if her name - [name_f]Lia[/name_f] - was ‘dramatic’ enough to pull that off. It got me to thinking: are some names more suitable for titles than other? I mean, some names, like [name_f]Ophelia[/name_f] or [name_f]Anastasia[/name_f] are obviously up for the job, but so are some others - like [name_f]Matilda[/name_f], [name_f]Tess[/name_f], [name_f]Alanna[/name_f], [name_f]Charlotte[/name_f]. Is it just a matter of perception, or are there actually qualities a name may or may not have that inspire that effect? What names work for you?
Names don’t have to be dramatic to work in a novel. Does [name_m]Harry[/name_m] or [name_f]Katniss[/name_f] or [name_f]Beatrice[/name_f] or [name_u]Kelsey[/name_u] or [name_f]Hazel[/name_f] sound dramatic to you? Btw, those are the main characters of some of my favorite books. Overall, as long as you love the name, it works for your character. 
And everyone has a different perception of drama and beauty. As I said before, whatever makes you - as the author - happy works. 
I think any name can be used as a title, provided it fits the story to do so. [name_u]Unique[/name_u] names work because, obviously, they stand out and set the novel apart. But common names can work too, for different reasons. It’s a focus on the character. I have a short story titled “[name_u]James[/name_u]” that was written for the sole purpose of exploring one character. The focus is so strong that the narrator’s personal life outside of the title character is only ever mentioned in passing. Because even though she has a life outside of [name_u]James[/name_u] and I do try to indicate that, that’s not what the story is about, so to include too much would be jarring. The title “[name_u]James[/name_u]” in itself might not seem very striking, but given the story it goes along with, I can’t imagine any other title fitting. It’s about [name_u]James[/name_u].
On the other hand, names that already have a lot of associations with them - like [name_f]Ophelia[/name_f] - I think are actually even harder to pull off than more conventional character names, simply because of all the connotations one has to consider that may or may not apply to that book’s themes. Like, if you have a character named [name_f]Ophelia[/name_f], and her name is treated more as a sticking point against her parents than a foreshadowing of any themes about madness or suicide, calling the story [name_f]Ophelia[/name_f] could be misleading. On the other hand, if you have a character named [name_f]Ophelia[/name_f] who unfortunately also happens to struggle with a mental illness, and has to deal with the stigmas associated with it and the assumptions others make about her, that could be a place where titling the book after the character could play into those themes.
That sort of thing is complex, and I’m not sure my brief ruminations mean a whole lot. I’m just thinking to myself. It is a good question.
What I’m trying to say is: I don’t think a character’s name needs to be particularly “dramatic” to be used as a title. It depends mostly on the character themselves (if they’re distinctive and enough to warrant such treatment) and the story (its focus, its themes).
So if it fits the story, I say go for it. But if you’re not sure, that’s only one obvious option, so there’s plenty more out there, most of which will probably be a bit more interesting than just a name, if that’s your concern. My story is never getting submitted for bookstore publishing, since it’s just a character exploration in short story form, so I didn’t really worry about audience. (Edited to add this because [name_f]Kala[/name_f] below me mentioned books on shelves and I wasn’t even thinking in that direction yet haha. But what she says is correct.)
Would you pick up a book that was just called ‘[name_f]Anne[/name_f]’? Maybe, but it likely wouldn’t sell well. [name_f]Anne[/name_f] of [name_u]Green[/name_u] Gables on the other hand has a ring to it.
I’m often leery of books that are titled with only a name. In my experience they usually turn out to be poorly written romance. [name_m]Even[/name_m] the ones you mentioned, most aren’t titled with only that name. It’s not [name_f]Charlotte[/name_f] it’s [name_f]Charlotte[/name_f]'s [name_m]Web[/name_m]. [name_f]Tess[/name_f] is [name_f]Tess[/name_f] of the d’Urberville’s. It’s not that it never works, but you have so little you can give to a prospective reader. It feels like missing a chance.
So, yes, I think [name_f]Lia[/name_f] could work as a main character name and could sound well in a title, but I’d probably give the reader a little something more.
Like:
[name_f]Lia[/name_f] Dreams in 3D or [name_f]Lia[/name_f]'s [name_u]Ocean[/name_u] or [name_f]Lia[/name_f] the First or [name_f]Lia[/name_f] of Bangladesh or [name_f]Lia[/name_f] and the Zealot
Doesn’t need drama. [name_m]Just[/name_m] don’t have it be disgustingly common.