Your personal preference may vary but I used to sleep on a spring mattress for many years and had back pain from sleeping on the spring mattress and the springs in the mattress weren't supporting me comfortably enough.
I decided to switch to a memory foam mattress and I sleep much better and have no back pain while sleeping either and I wake up fully refreshed since I never toss and turn to get comfortable on the memory foam mattress like I used to on my spring mattress.
So yes in my opinion at least memory foam mattresses are more comfortable and much better to sleep on than the spring mattresses.