When I used to paint I used acrylic paint and brush or water color and pencils. I use photos as reference and like to be as realistic as possible and sometimes exaggerate details.
On Moderskeppets blogg I just red about Bert Monroy who take it to the extreme using Photoshop and Illustrator to make Hyper Realistic Art. Bert also share his knowledge on Revision 3.com.