It will be as good as any 20 year old vehicle theoretically.
Whether it is good to you or not is solely dependent on miles, condition, maint and repair records, how often it’s been driven, what it was used for, how it was stored and where it was driven (rust).
Presuming you don’t know much about vehicles or you wouldn’t be asking.
The absolute best thing to do is take some one with you who can determine and understand the things I listed above.
Then realize that regardless of what the asking price is, it’s only worth a couple grand.
Then know that no matter how nice it is, it’s old and be prepared to spend as much or more than the purchase price in repairs and maintenance.
This is the big one.
Presuming whatever you look at is in good shape, you should be looking for the one that has a page long list of parts replaced reasonably recently. One that’s “never needed anything” and runs great WILL need the list of parts soon based solely on age at the best case and all the other stuff as well.