SSDs have a definite positive performance impact for editing photos, especially when using programs such as Lightroom that also manage photo libraries/databases
Actually Lightroom works well with hybrid drives. You're using going to be building 1:1 previews anyway on a fast scratch drive and RAWs on a cheap storage option. Any RAWs you're working with will be in ram anyway.