All-in-One Library?

Gog galaxy does that. I did not use it for psn but they clearly have a plugin for it.

I use it for all ubi/prime/epic/ea/xboxlive.

And they have some others (it may be a bit tough to set some obscure ones)

Playnite is your all-in-one, open-source video game library manager and launcher. It simplifies your gaming experience by offering support for a wide range of third-party libraries like Steam, GOG, EA, Battle.net, and Ubisoft Connect, as well as emulated games. Playnite provides a unified interface in both Desktop and Fullscreen modes, allowing you to effortlessly organize and launch games. It also offers features such as playtime tracking and the flexibility to enhance functionality with custom add-ons and themes.

https://playnite.link/

I think Playnite is what you're looking for.

I personally like using isthereanydeal to track my owned games because with the Augmented Steam browser extension, you can make it highlight games in your ITAD collection as owned on Steam. It's not really good for tracking retro or console only games though.

I like using HowLongToBeat to track my general backlog of games I want to play and complete, but that's because I just like tracking game times, and just like that it's easy to use, and looks pretty.

For here I just ignore games I own in other places so as not to enter giveaways for them.

For launchers I personally just use Steam's Non-Steam Game feature and Steam ROM Manager to help easily import stuff in Steam. This mostly has to do with the fact I like using features like Steam Input, Screenshots and now the recording beta. That being said, I totally +1 Playnite as I found it super customizable and the plugins support is amazing, allowing you to make things look how you want and being able to easily map as much or as little info you need for all sorts of games. I honestly got addicted just playing around with it and trying to perfect it. I wish both Steam ROM Manager and Playnite worked better with DRM-Free games not tied to a launcher though.

I use backloggery.com, but you have to enter everything manually. They just updated their backend to be more robust.

Launchbox.

...from Reddit...

Playnite: The one with the most features and libraries available via addons and has a lot of options for customization. In my opinion the best one available for this purpose. Learning curve can be difficult for some people due to the amount of features and options and UX could be improved but you can refer to the manual, subreddit or Discord if you need help.

LaunchBox: Focused on emulation but has support for some of the most popular PC storefronts. Has some features, including the Big Picture Mode (Controller mode), locked to the paid version. Also be aware of RAM usage, last I checked it used a ton of it because loads the images for all the games in your library but that may have changed.

Heroic Games Launcher: Support is limited to Epic, GOG and Amazon but the advantage is that it can manage their games itself without the need of their own launchers.

One Game Launcher: Works as a Windows widget. Supports the most popular stores and while features are limited, it should work if you don't need more "advanced" features other than viewing and launching games.

Alfae: Supports a limited number of stores and doesn't seem to have support for more advanced features like filtering, which in my opinion is a very important feature.

GOG Galaxy: Unfortunately integrations quality leaves a lot to be desired, with some having bugs and others not working. I also have some issues with the client, like performance tanking once you have a few hundred games in it. It also seems that the client is no longer being only actively developer and remains in basic maintenance mode, with some updates from time to time to improve stability.

The thing is... Playnite/Galaxy are for PC games (and by extension Xbox in some ways). Neither of them can be used on PlayStation however, and from what I understand you want to view your PlayStation library too...
Correction: While Playnite can only run on PC, it can still log your PlayStation library (using an add-on).
Someone mentioned backloggery.com, that's closer to what you're looking for. Yes, manually entering stuff is going to be a bit long and annoying, but that will be the only way to get all your games from PC/Xbox/PlayStation/Switch and anything else.
Alternatives are backloggd.com and HowLongToBeat.com (I personally use the last one, didn't like the previous, didn't try the first).

That's what I was thinking about, I don't know any sites that will automatically tell you what you own. I think GOG does it to some extent, but that's all I've ever seen. You could try something like Playtracker.net, it will show you Steam/GOG/Epic/PSN/Xbox/etc., but for PSN/Xbox it only shows you things you've actually played.

I've been wanting to find a backlog thing like BLAEO that supports PSN/Xbox and such though, that'd be dope.

Edit: definitely going to check out playnite though.

Ok, so I just downloaded Playnite based upon all of the recommendations here, and it looks really cool. I can't use it yet, though, because it's still parsing through metadata for my library...and it's been doing that for almost two hours. And it's less than half done. Once I combined Steam/GOG/XBOX/UBI/EA...hooo boy.

I've come to the conclusion that I own too many games. 🤣🤣🤣

It'll be a drop in the bucket at this point, but since you can manually add things, I'll eventually need to get all of my Atari cartridges and PS/2 discs added into the collection as well. LOL

I decided to reopen the old thread https://www.steamgifts.com/discussion/lKZuz/playnite-the-one-launcher-to-rule-them-all-yes-including-steam-yes-including-gog-galaxy, since there is renewed interest in Playnite.

Discussions about Playnite could be held there, since this thread here was a user asking for a tool and he got his answer.
Just a thought :)