Hrm... Well, in the original context of 'running off your normal actionbars', you could just swap items into those slots (PickupContainerItem() then PlaceAction()) as need be while outta combat, without dealing with secure frame madness at all.
Following off of Nymbia's suggestion, you can do simple macros to /use an item by name, but I don't know of a simple way to do it by category. Myself, I carry one kind of food or water at a time and I tend to stick to it for a while, so it's a small thing to change macros when I change binds and start buying something else. (Did Consumer do categories? I never used it.) You can do some fancy stuff with modifier keys too. None of these are for food/water, but you get an idea: http://www.wowwiki.com/Most_Used_Macros