Welcome!
Great backstory, I think it captures why many of us still love these cars.
So you covered a lot of ground I'll try and hit on some points, not to scare you off but to inform.
If you encounter a 1991 with ABS, don't walk, RUN. That was the last year the old PowerMasterIII braking system was offered in these cars. It was troublesome 35 years ago and in my opinion totally unsafe to use today, and its a massive headache to get rid of. Just spend some time reading here and you'll see. 92/93 had a far more reliable however underwhelming performance of the Teves IV ABS System.
the "high oil pressure" is likely nothing more then a bad sending unit, when they start to fail they will read all over the place, $20 for a new one no big deal
A 1992 will have the highest possibility of being a manual, not sure on production numbers but 1992 was the most common year for manuals, again still very uncommon but highest chance.
As far as automatic vs manual, I've done both flavours of the 3.4 DOHC, the 5 speed is more fun but its truly a hateful gearbox to live with on a daily basis. I'm good with it for a few days before I get sick of it, your mileage may vary.
There is also the reoccurring problem of these cars in the 5 speed manual, no parts! you can get axle seals, clutch sets, sometimes clutch hydraulics and not much more. Shift cables are another issue they don't break often, and you can repair the main shift cable when the rubber bushings fail. But the cables themselves, they are unobtainable now.
And lastly Timing belt components are getting harder to come across, specifically the timing belt tensioner actuator, its been discontinued by GM and you're basically scrounging old stock or used ones at this point. Literally no idea what I'll do next time I need one. Probably have to get creative.
The video of that 91' you posted sounds in a pretty sorry state, could be something simple. Can't really tell from the video.
Of the 2 you are looking at the white one with cloth looks better taken care of.
That said, If you do want one try and hold out for a nice one, at least around me these cars are just gone from junkyards so replacing broken pieces could be a challenge.