I built a new kitchen about 18 months ago and installed a built in fridge. It fitted behind cabinet doors so needed to be no more than 600mm wide (about 24inches). The kitchen sits in the living/entertaining area so we didn’t really want any of our appliances on show.
The biggest I could find that fitted was about 9 sq ft (216 litres) which was a lot smaller than the 18 sq ft we had used before so we put the old fridge in the utility room to give us 27 sq ft of fridge/freezer.
How has it worked. Its been pretty good, we have moved the larger fridge from the utility room which was down a flight of stairs to a large cupboard in the hall on the same level. Before we did this we were getting annoyed at running up and down stairs to the fridge, the new position isn’t a lot closer but no stairs make it far easier and less of a phycological barrier.
I have found we quickly came to organise the fridges differently. The small fridge has all the sauces and condiments for cooking; the milk and butter we use every day; cold water and juices; ice for drinks; open bottles of wine etc. It has space for dishes getting cooked i.e. keeping prawns cool after they are cleaned but before they go on the stove. The big fridge is filled after the weekly shop (its near the front door so convenient) and has all the vegetables, fruit meat, dairy, beer/wine and soft drinks and pre-prepped frozen dishes.
When I cook I just go down to the big fridge and get out the ingredients for that meal and move them to the kitchen and/or small fridge. In hindsight we probably could have had a bigger fridge to freezer ratio in the small kitchen fridge, as we only really use for ice) for drinks) and frozen pastry - but there aren’t too many options with these size fridges it seems to be 50/50 or 100% fridge with no freezer.
Overall we are really happy with the two fridge system although it takes a little while to adapt.
One observation about your kitchen - your top cabinets are quite shallow. If you put in a fridge that comes to the counter edge it could be good to install top cabinets that do the same so it looks neater. You could even lose the small bench and add a floor to ceiling cabinet next to the fridge to give extra cupboard space. Overall far neater.