The ESP32 memory map implementation cannot map more than 4MiB of RAM into data memory because of a hardware limitation
Afaik this limitation is also valid for the App Partition size.
That’s would be a possible reason why there is no App partition available with a size greater than 3 MB in ArduinoIDE.
Afaik this has been fixed on ESP32-S2 / S3.
See also How to use the full size of the partition with PlatformIO with M5Core2? - #3 by maxgerhardt