indeed
i always work in RGB and then switch it to CMYK and make any touch ups [if needed] afterwards
i know a lot of colorists who just color straight in CMYK
just takes a little bit of practice i guess. You work in it and with it long enough you will know what colors work for CMYK and what dont.
Usually for me its things like blues, purples, magentas. stuff like that. All it usually takes for me is a little adjusting in the hue/saturation department to get things to work for what i want them to.
if you're coloring [in photoshop] in RGB and you wanna see how it'll look in CMYK just hit ctrl and y and it'll show you how your colors would look in CMYK mode. It helps to make better color choices, that way you can easily adjust it right there while you're working because sometimes its a little difficult or can end up looking kinda tacky if you wait til after [like i do a lot of times

]
hope it all helps. i'm no expert but if you have any other questions i do have a lot of other professional colorist friends who have plenty more experience and know-how about working for print than i do. i can pass along any questions or whatever.
but really its not too difficult. the biggest thing is to make sure your monitor is calibrated as close as you can get to how things look when they're printed. i adjust mine to match up with copies of the comics i work on every now and then just to make sure the end result in print looks as close as it can when its on my screen.