Some trophies can invite to play something you would naturally miss, an area or different playstyle, and so expand the experience, inviting you to do something differently. Those are usually interesting.
Sometimes even NG+ can be interesting, if they allow to ignore anything but the main story and you get the experience the game propably should be in the first place without the usual open world skill tree garbage all games seem to have today.
Collectibles are 99,9 of the time just a waste of time. Text logs should be a thing of the past anyway and some vases, coins, relicts, magazines or whatever shit is usually pointless and still requires someone to modell them for the short ..bling... you found this! celebration.
Dumbass do action xy a thousand times, can burn in hell, and I only do those if the time requirement is not too excessive and if it would be the last trophies for a platinum.
Time investement in general is a deciding factor if I try to care for any. eg F1 23 requires you to play at least a couple of weeks online against all the other people trying the same and competing for a rather limited amount of places. Some people fair, some stupidly aggressive and unfair, everything about that was the opposite of fun, so I aborted it in week 2 with just the first trophy of that type and saving my nerves some stress and probably 20 or much more hours of a merciless grind. Also assuming some PC players using cheat stuff, due to impossible behavior... In theory it could be fun and it was fun at the beginning, but once on level 3, with collisions active, the fun went out the window.