Unclear error message "Can't determine project language from files" during debugging, when there actually are issues with local.settings.json

When debugging a .NET 8 Function locally, and there is a syntax mistake in the local.settings.json file,, the 'func host start' and 'Azure Functions core tools throws the same unclear and not so helpful error:

`Can't determine project language from files. Please use one of [--csharp, --javascript, --typescript, --java, --python, --powershell, --custom]`

This is a very unclear error message and after some trial and error I found out it was due to a syntax mistake in my custom config settings in local.settings.json.

How to reproduce:
- create new time triggered (or any other) Function using the VSCode wizard
- extend local.settings.json with the custom setting as found below

```
{
"IsEncrypted": false,
"Values": {
"AzureWebJobsStorage": "",
"FUNCTIONS_WORKER_RUNTIME": "dotnet-isolated",
"ConfigSettings:ServiceBusQueues": ["my-test-queue"]
}
}
```
- press F5 to see the error

The mistake (now) obviously is in the fact the local.settings.json doesn't support arrays and I should specify it as:
` "ConfigSettings:ServiceBusQueues:0": "my-test-queue"`

Although I suspect there can be many reasons for this error to show up, it would be helpful to have some suggested causes as searching for this error also doesn't give many results.