LOL, love the "experts" chiming in.
My father owns a car lot where he has sold only low mileage, rebuilt title cars for 30+ years. He sells 65-70 vehicles per year. It is a small community (~6k people), and he has built a reputation for himself with the public and the banks. He uses the same body shops to have the cars rebuilt that would fix your car if it was an insurance claim.
Parts of almost all previous posts are true. My suggestion would be to 1. know/trust the person that is selling the car, or if this is not possible 2. ask what was wrong with the car, then take the car to a body shop, esp if you have someone you trust in the business, to have the car inspected.
Factory warranties are cancelled when the title is salvaged. Used car dealers sometimes offer their own warranties, or have warranties available for sale. All of them I have ever dealt with do not exclude rebuilt vehicles.
My father receives the same value for his vehicles as if they had never been wrecked. Some problems you may run into with the value of the car is a) if you wreck your car, and the insurance company wants to pay you less because it has a rebuilt title. The best plan for this is to ask them when you purchase the insurance. They never give you a break on insurance because it has a rebuilt title, but seem to want to pay you less when it comes time to settle. b) If you were to trade the car in to a dealership that does not deal with rebuilt title cars, they may not want to give you full value for the car. If, however, as you state, you are looking to drive it until it lost much of its value, this will not make a difference.
There are horror stories of cars that have been rebuilt. Just like any business (construction, landscaping, etc.) there are people that will use inferior supplies, not do the job right, and will try to put a facade on poor work. If you feel this is the case, do not purchase the car. That is the reason I recommend getting it checked out by a professional auto body specialist.
Good luck, PM me if you have any other questions.