In a technical sense it makes no difference whether it is a large ship or smaller ship
I assume smaller ships are less detectable than a large ship. Not sure by how much.
Smaller ships can be faster. They can complete their mission and get back before getting blown out
Smaller ships are more expendable than larger ships. It costs less, has fewer men and lesser equipment
Beyond a certain point making a ship larger does not make it more capable
The larger LCF (6k ton) is a more stealthy design than the Tromp class AAW frigate (4.3k ton) and L-class frigate (3.75k ton) it replaced. This makes it LESS detectable even if bigger. Advances are also made in e.g. noise reduction and reduction of heat signature.
In chronological order:
Tromp frigate (dedicated AAW and command ship) > 28kn (4.3k ton) COGOG complement: 306
S frigate (general purpose version) > 30 kn (3.9k tons) COGOG complement: 176–196
L frigate (same hull as S but AAW version) > 30kn (3.75k ton) COGOG complement: 197
M frigate/ Doorman class (replacement S) > 30kn (3.3k tons) CODOG complement: 154
LCF/Zeven provincien (replacement Tromp and L) > 30kn (6k ton) CODAG complement: 232, €600 million/ship
I don't see a speed difference that is related to size.
Note Holland class OPV is 3750 tons, like L-frigate, but max speed is just 22kn. Reason: it has all diesel CODELOD propulsion rather than a combination of diesel with gasturbine as found on the frigates. Complement: 54 (+ additional space for 40). US$150m/ship
How is a more stealthy 3,200 ton Formidable class ship (Singaporean navy), with 32 VL Aster 15/30 (30km/120km), more expendable than a less stealthy 4,035 ton Talwar class ship (Indian navy) with 24 × SRL Shtil-1 (32km) and - in first three only - 9M311 / NATO SA-N-11 (10km)? Both have 8 AShM. ASW tubes and 1 ASW helicopter. Or a larger (6k ton), similarly armed (with 2 helicopters but no ASW tubes, and Barak 1 VL in place of SA-N-11) P17 Shivalik?
Look at the complements. Not how the S and L frigate have fewer crew than the Tromp, while not very much smaller. This is because they are newer and more automated. Compare S and M frigate: likewise, even if the M is a bit smaller. Compare Tromp and LCF: the latter is much larger but has much less crew. Compare Holland OPV and L: same tonnage but much much less crew due to fewer military systems (and hence specialist personnel) on board + automation.
I'm not sure that a small ship like UAE Baynunah class (915 tons) costs less than a 1520 ton Comandanti class ship or 1620 ton Abu Dhabi class ship based on it. It certainly has more weapons.
https://en.wikipedia.org/wiki/Baynunah-class_corvette
https://en.wikipedia.org/wiki/Comandanti-class_patrol_vessel
https://www.fincantieri.com/en/products-and-services/naval-vessels/comandante-cigala-fulgosi-class/
https://www.fincantieri.com/en/products-and-services/naval-vessels/abu-dhabi-class/
When we have Anti Ship Ballistic Missiles such as Dhanush why make such huge sitting ducks?
When our rival navy the PN has small barely armed frigates such huge destroyers are a waste of money
If you pretend that PN is your (only) future thread, then don't get huge destroyers.