Artists for every budget: from a canvas for £150 to a photo that fetched £2.7m