Generally, no.
IF you are in a hot housing market, and IF the renovation will return more than 100% of its cost considering the state of your home/office and whether you are overimproving for the neighborhood, and IF you plan to sell soon enough that the reno will still look fresh/new/modern, you might make some money off of it. But all of those "ifs" make it a longshot, especially when you consider the other investments you could have thrown that money at.
I have thrown a ton of money into my house. I will probably get some of that money back when I sell. But I made the choice to renovate assuming that I was investing in my own personal happiness and comfort in the place I plan to stay forever.