We always spec "stained" grade maple for our stile and rails and a MDF center panel for all painted doors/panels

Stained grade maple is a grade of maple that does not make the grade for clear grade maple but is perfect to paint

Our kitchen has painted cherry cabinets. The insides of the cabinets are beautiful when you open the door.

The upcharge for painted cabinets is likely to be as much or more than the upcharge for stained cherry. For your lesser used rooms, consider oak cabinets. It's the cheapest wood option. If you must have a painted look, go for a partial overlay door in a recessed panel as that will be the least expensive choice. The standard for painted cabinets is maple as it takes painted very well, and is hard enough to withstand some knocks without denting.