Lucky for you, Shaker style cabinets are a classic that can go modern or more traditional with a change in hardware, AND they are stock items in some of the big box stores now. An apron sink may or may not work with the existing base cabinet- check the specs carefully. The color you choose for the additional cabinets should be based upon your new countertop. You might consider a color, white, or just go with a deeper stain on the new cabinets. Resist the urge to go with gray, which could make your existing cabinet wood look orange. Switching out the brown traditional hardware for a more sleek bar-style handle in brushed chrome would be a nice update as well.

Painted cabinets are making their way into the trend market in a big way!! sooz001 is correct, your color will depend on the granite, quartz or other material color you choose. Here are a few examples: