Cannot retrieve latest version of some NuGet packages via CodeArtifact

I have followed the instructions from CodeArtifact documentation to establish

• nuget-store repository with external connector to NuGet
• internal repository with upstream to nuget-store repository

When re-configuring Visual Studio 2022/NuGet to use the CodeArtifact as source, it seems to work. However when testing with our app teams' application solutions, it seems to fail to find the latest versions of some specific packages.

Severity	Code	Description	Project	File	Line	Suppression State
Error	NU1102	Unable to find package DeepCloner with version (>= 0.10.4)
  - Found 12 version(s) in appssamples [ Nearest version: 0.10.3 ]
  - Found 0 version(s) in Microsoft Visual Studio Offline Packages
  - Found 0 version(s) in C:\Program Files\dotnet\sdk\7.0.304\Sdks\Microsoft.NET.Sdk.Web\library-packs	APPROJECT	
Error	NU1102	Unable to find package Humanizer with version (>= 2.14.1)
  - Found 83 version(s) in appssamples [ Nearest version: 2.13.14 ]
  - Found 0 version(s) in Microsoft Visual Studio Offline Packages
  - Found 0 version(s) in C:\Program Files\dotnet\sdk\7.0.304\Sdks\Microsoft.NET.Sdk.Web\library-packs	APPROJECT
Error	NU1102	Unable to find package SimpleInjector with version (>= 5.4.1)
  - Found 181 version(s) in appssamples [ Nearest version: 5.4.1-beta2 ]
  - Found 0 version(s) in Microsoft Visual Studio Offline Packages
  - Found 0 version(s) in C:\Program Files\dotnet\sdk\7.0.304\Sdks\Microsoft.NET.Sdk.Web\library-packs	APPROJECT

The latest versions of above packages could strangely be retrieved after I disabled the "Microsoft Visual Studio Offline Packages" source. But in their place, another set of package versions can't be found for other projects.

Severity	Code	Description	Project	File	Line	Suppression State
Error	NU1102	Unable to find package Humanizer.Core.af with version (>= 2.14.1)
  - Found 22 version(s) in appssamples [ Nearest version: 2.13.14 ]
  - Found 0 version(s) in C:\Program Files\dotnet\sdk\7.0.304\Sdks\Microsoft.NET.Sdk.Web\library-packs	APPROJECT
Error	NU1102	Unable to find package Humanizer.Core.ar with version (>= 2.14.1)
  - Found 22 version(s) in appssamples [ Nearest version: 2.13.14 ]
  - Found 0 version(s) in C:\Program Files\dotnet\sdk\7.0.304\Sdks\Microsoft.NET.Sdk.Web\library-packs	APPROJECT
Error	NU1102	Unable to find package Humanizer.Core.az with version (>= 2.14.1)
  - Found 7 version(s) in appssamples [ Nearest version: 2.13.14 ]
  - Found 0 version(s) in C:\Program Files\dotnet\sdk\7.0.304\Sdks\Microsoft.NET.Sdk.Web\library-packs	APPROJECT
Error	NU1102	Unable to find package Humanizer.Core.bg with version (>= 2.14.1)
  - Found 22 version(s) in appssamples [ Nearest version: 2.13.14 ]
  - Found 0 version(s) in C:\Program Files\dotnet\sdk\7.0.304\Sdks\Microsoft.NET.Sdk.Web\library-packs	APPROJECT
Error	NU1102	Unable to find package Humanizer.Core.bn-BD with version (>= 2.14.1)
  - Found 22 version(s) in appssamples [ Nearest version: 2.13.14 ]
  - Found 0 version(s) in C:\Program Files\dotnet\sdk\7.0.304\Sdks\Microsoft.NET.Sdk.Web\library-packs	APPROJECT
Error	NU1102	Unable to find package Humanizer.Core.de with version (>= 2.14.1)
  - Found 22 version(s) in appssamples [ Nearest version: 2.13.14 ]
  - Found 0 version(s) in C:\Program Files\dotnet\sdk\7.0.304\Sdks\Microsoft.NET.Sdk.Web\library-packs	APPROJECT
Error	NU1102	Unable to find package Humanizer.Core.el with version (>= 2.14.1)
  - Found 22 version(s) in appssamples [ Nearest version: 2.13.14 ]
  - Found 0 version(s) in C:\Program Files\dotnet\sdk\7.0.304\Sdks\Microsoft.NET.Sdk.Web\library-packs	APPROJECT

Don't understand what sort of behaviour I am witnessing here? Why is CodeArtifact's connector only able to retrieve the penultimate versions for those packages?