Seeking credit card ideas. I recently saw an advertisement through Chase bank that they offer low-limit credits cards for children. Any experience with these cards?

You can get "pre loaded" cards.
If the card will be in "Mr. ConnieCaretaker's" name and this is a new card, new account not sure if you can legally open a new account in his name if he is no longer cognizant, opening an account is a contract and he may not legally be able to enter into a contract.
I would talk to Chase and see what they say.
Opening an account in your child's name you are guaranteeing that you will pay if the child defaults. Would you do the same for an adult with dementia?
I would be very cautious of getting a card for someone with dementia particularly if there are going to be purchases that I was unaware of.

That question you need to ask Chase. They seem to have options credit card or debit but you must have an account thru them a a parent need to be involved.