A good mattress should be more comfortable and longer lasting than a cheap one, but only up to a point.
I would expect a £200 mattress to be better than a £50 one, but I doubt that spending £1,000 would produce much more improvement, let alone more than £1,000.