Get-AzSecurityAssessmentMetadata only returning 1000 results, even in the portal

### Description

When using the Get-AzSecurityAssessmentMetadata module (or the API or even the portal) only 1000 results are returned. We now have had multiple situations where we are trying to view one value, and it is not returned because the amount of results is above 1000. Can this limit be removed?
And yes I am sure the value is there, because I have been able to set it and remove it with the AZ powershell commands. The only issue is with GET results.

### Issue script & Debug output

```PowerShell
This is an issue in the portal as well as with the API and the AZ module.
```

### Environment data

```PowerShell
This is an issue in the portal as well as with the API and the AZ module.
```

### Module versions

```PowerShell
This is an issue in the portal as well as with the API and the AZ module.
```

### Error output

_No response_

Start by reproducing the result cap with the Get-AzSecurityAssessmentMetadata cmdlet and compare its response with the Azure API and portal behavior described in the issue. Determine whether the 1000-result limit is imposed by the PowerShell module or the service; done means identifying the responsible layer and either retrieving all assessments or documenting the service limitation.

Written by the indexing model from the issue text.