Photography is a very difficult skill to even max, not talking about supermaxing with its tricky collections and challenges...
It's not as hard to max as I thought - especially with the Fast Learner LTR. The harder part for me was remembering to have my sim take pictures. No photos = no skill up.
The things that really turned me off the skill were the fact that it is a money sink at first - and my sims never start out with a lot of extra cash - and the difficulty of the challenges.
Now that I see how profitable it can be, I would definitely consider it as a career. Because of all the immortal requirements for my photographer I most likely won't get to work on the challenges too much (painting is her supermax skill and career).
Good luck getting your Doubly Dead photo - when you get it please post a pic on the forums!
My sim saw a mummy when she was adventuring in Egypt, but she had no martial arts or athletic skills, could not reliably kiss a king cobra, and had future dynasty generations to consider. I was lucky to have her get a pretty bad photo (she was low level photography at that point), but I was more interested in having her escape unharmed.