The thing is 15 years old and there is no way to say if it is a good vehicle , dependable or will run for 1 day after you buy it or longer. It is on a dealer lot so they might let you take it to a shop for inspection but then again they might not .
You are buying a used vehicle so anything you have heard is just that , something that you heard and will not apply to every 2004 Tahoe.