I don't disagree with your "enjoy the moment" thesis, but I also envy your memory recall capability. For me, photos can resurrect memories I don't have access to normally.
That being said, I have far too many photos (and camera bodies!).
I do not take photos for the memories, I take photos for art and I do go back and look at them.
My camera is for art, and in my mind this an entirely different thing than recording stuff with my phone. These are as different as using writing utensils to briefly write notes vs. using them to make a complex drawing.
I don't really see the point of taking vacation photos that don't have me (or whomever I'm traveling with) in them; you can find higher quality photos of virtually anything I'd take a picture of on the internet for free; the only thing I can realistically add to the photo is me!
One of the first digital Ixus (IV maybe? from 2000?) made images of just one megapixels, but they were amazing. I miss that thing.