If you don't care about playing the latest games and you have a somewhat varied taste I would argue the Extra tear is definitely worth it for a newcomer to the system. Specially if you wait for a sale (there will probably be one on Black Friday).
You get access to a bunch of cool, albeit older, exclusives like Returnal, Ratchet, Demon Souls, TLOU1 Remake, a bunch of nicely enhanced Ps5 version of games like Tsushima, Miles Morales, Death Stranding, etc and a metric ton of indies and older AAA games.
The regular PS+ I'd say is only worth it if you want to play a lot of online stuff. If you want it for the "free" monthly games I'd argue you are probably better off spending the money buying 2-3 specific games you want (on sale) instead of hoping the selection of titles over the next 12 months will be to your liking.