I have a Canon G3 that I take with me on trail rides fairly frequently, but I am always forgetting to stop to take pictures. The camera is kind of bulky compared to most popular dig cams, but it's what I have and I really like the pictures it takes. Haven't ever taken it on road rides, mostly because it fits best in a Camelpak due to size and it's case.
In a perfect world I would have a Elph and a digital SLR for different purposes.