To wit: PipePipe is the only one that works for me now to get past the "log in to confirm you're not a bot" viewing any video. Recent PP releases allow you to log into your YT account (which will also solve this age problem), my ISP uses CGNAT and my IP is shared by millions and changes frequently triggering the YT bot filter for every video. :-/
If you own a domain, hosting Forgejo on a $5 Debian cloud server works perfectly for your personal use case. My site admin panel shows it's using 75MB of actual RAM (not allocated/virtual), it's truly very lightweight. Disk use is very low, just however big your git repos actually are is the key.
The internal SQlite database option is just fine, don't need to bother with PostgreSQL if you're only doing it for yourself (the DB only holds referential info, the actual git data is stored on disk in normal git directories). There's a built in backup command so you can build a simple shell script to run the dump command periodically and back up the entire thing to a tarball.
re: Codeberg, the only "downside" (not really) is they are for FOSS licensed projects only and frown upon using their service for your personal private non FOSS needs (they're not draconian about it, but it's part of the ethos the service is for FOSS licensed projects to use).