Mine is awaiting me in a warehouse, so I haven't used it yet, but I chose the Marvel refrigerator drawers, 24" wide. One of the features I like is that you can stand a 2 liter soda bottle, and reputedly an opened bottle of wine, in the lower drawer. The drawers also seemed roomy to me. My 17-year-old one has a swing door. It works fine, but for sodas it's a pain because it's hard to see the ones in the back. In drawers it's hard to see the ones underneath. For veg, it's impossible to find things without taking them all out. That's why I chose drawers.

We have both an undercounter microwave and a beverage fridge. I bend down a little for the m/w controls, but 99% of the time I'm using the same buttons - open/close, stop/pause and the numbers to set time - I know their location now, so I just knuckle the panel and I'm set. The beverage fridge, I do have to go into a full deep-knee bend to grab things, but it's an alcohol-only fridge, and I use it a lot less than if it had, say, bottled water or if I stored juice/soda for children in it. BTW, we ended up with a beverage fridge instead of wine fridge because Spouse is a big beer drinker, and most of the wine-fridge racks had slats that were too widely spaced to hold bottles of beer. Even 25-oz bottles of many microbrews and imports are skinnier than wine bottles, and slipped right through the slats when we tested empties at the appliance store. We have the obligatory few bottles of wine on the slats, removed one glass shelf so as to accommodate taller beer bottles, and the fridge works fine for our needs.

You just described a standard refrigerator freezer with an ice alert. Make room for a 28" top mount one and call it done. You'll get tons more capacity for a lot less money.

Not sure there are undercounter units that will store 50-6- bottles. We installed a U-line ((WC1224) in our apartment renovation and are very happy with it. We are using the same unit in our kitchen renovation in our country house. It is pretty quiet, reliable and not crazy expensive.