I've painted a lot, and there is absolutely NO reason you have to use oil-based paint on cabinets. The worst part about oil-based paint is the fumes that are emitted while it is drying, which can take about 3 days. The fumes from oil-based paint are way worse than from latex paint.
However, if you want low voc paint, it's more expensive, but if it will make you more comfortable, do it.
I've painted kitchen cabinets with latex and it worked fine. I would never use oil based paint. Also oil based paint yellows over time, and if you ever want to repaint it, you have to use oil based again, or else prime it first. Don't use it.