I’m from [name_u]Sydney[/name_u], Australia & I had never heard of it before coming to this site. It has a pleasant enough sound to it.
The few Cadences I know do have parents with a lower socioeconomic status, but I don’t think it’s trash. The real spelling also looks pretty in writing, I guess because I like longer C names like [name_f]Catherine[/name_f] and [name_f]Cecilia[/name_f]. It probably suffers from being a newer name with many variant spellings, so it doesn’t quite feel like [name_f]Melody[/name_f] or [name_u]Harmony[/name_u] to me.
But if there isn’t much use in Australia and no real stereotype for it there, I’d say use it. I know I’ve been disappointed to see a few names I like are low-class in [name_f]England[/name_f], but since the US has a different “naming culture” I try not to worry.
I knew a [name_f]Cadence[/name_f] and she was a spoiled little brat… Because of that I do not like the name. However, if you don’t know anyone buy this name that is as horrid as the girl I know, you could use it if you like 
[name_f]Cadence[/name_f] is fine. It’s the tacky variant spellings that bother me.
A name is more than a collection of sounds and letters. It has meaning, and so I think parents should know exactly what a cadence is and how it fits into music theory if they’re going to use the name.
If parents choose [name_f]Cadence[/name_f] without knowing, I think it compromises the overall integrity of the name for musicians and artists who would use it more meaningfully as a name for their child. If I were to meet a child named [name_f]Cadence[/name_f] whose parents didn’t understand music theory, I’d be a little embarrassed for the parents, and feel a little sorry for the child.
To me, it would be like parents using the names [name_f]Verity[/name_f], [name_f]Amity[/name_f] or [name_f]Prudence[/name_f] and not understanding that they are words for different virtues.
I recently met an adorable 1yo [name_f]Cadence[/name_f] with very classy parents, so I have a really good association with the name. As a musical term I think it works well as a name and has a nice meaning. I wouldn’t call it “insubstantial” at all.
Its not terrible, I don’t immediately associate it with music either though. Its ok