You will typically need a tool like Save Wizard to "re-sign" someone else's save file to your own PSN profile.
Remember: the modding community built these save files out of passion, not profit. If you enjoy a particular save, credit the creator. Leave a comment, share a YouTube video, or donate to their Patreon if offered. That support ensures that even with servers gone, the art of the CAW never dies.