Renovations or finishing a basement does add value to your home. While a basement space isn't worth as much as an equivalent space on the ground floor in most cases, in-law suites and similar uses of your basement substantially increase the base value of your home and its appeal to buyers.
You'll also reap benefits yourself from the added space or possible secondary benefits like improved insulation affecting your home's energy costs.