Could it be used to show off pictures? Sure.
Is it cool? Only to people who haven't seen an iphone or ipod touch and /or those who buy / love apple products simply because they are apple products. I'm brand-agnostic but the ipad is old tech in a larger form factor, and last time I checked that was moving backwards.