I usually try to model all my props myself, but for this one I used a lot of free assets from itch and other places, just searching for anything low-poly or "PSX". But I always model my own environment (e.g. the building). I use blender for modelling and unwrapping, and position things in the engine. I draw my own textures or make them out of snippets of photos.
For Godot, you export as .glb, I don't think there are any export settings you have to have like in Unity, but I like to remove the Mesh -> Images from the Data category so it doesn't export the texture with the .glb. The most important thing is to Apply Transforms after you're done modelling, a lot of people forget about it and it's really frustrating when you import a model with (0.01, 0.01, 0.01) scale and (-360, -90, 0) rotation lol. Whenever I import a model I get from someone else I always have to import in in Blender first and fix all the issues. Sometimes it's easier to just model things yourself to be honest
The "PS1 style" is really just 3 things: really low-poly models, small-resolution textures (128, 256, in this case I was doing 1024 because I didn't want it to be too pixelated) and low render resolution (taking a smaller screen and rendering it on a bigger screen, essentially). If you want to go full-on into the "PSX" aesthetic, you can add a shaders that simulate how PS1 was processing graphics - vertex wobble, dither, etc. This video might be of use.
I've never followed any guides, just kinda started doing it. I'm still an amateur in many ways and am slowly learning the skills. I didn't touch UV unwrapping for a long time, resorting to auto unwraps, but I do it now and it's fun! (and whoever is doing the textures will thank you)