I wouldn't do it in a kitchen personally, but would consider it in bathrooms. We did a paint followed by bar top expoxy in the guest bathroom.
Counters in there will be redone when we re-do our kitchen in the next couple years. Nice enough as a stop gap, but, as mentioned, you wouldn't confuse it with a real solid surface counter. It was a really ugly counter though and looks a hell of a lot better now. Doesn't see enough use to really determine durability.
Followed these basic steps.
http://adaesthetic.com/spray-painted-bathroom-counter/The stone paint i bought was too dark, so I followed up with a light spraying of a light gray paint. Then added just the slightest touch of a spay on glitter to get some of the shiny surfaces that comes with stone.
Hardest part of it all was taping and covering everything up. Just a couple hour job over a few days for drying times to finish an 8' counter.