The right mattress can considerably add to reduced back and neck pain, and increase the ability to feel rested after an excellent night's sleep.
You can get overkill if you want it, however generally you can get a quality mattress for between $500 and $1500.