Underrated pros and cons worth the hype? [v5]

This came up at a meetup recently and the room was split, so curious what the broader community thinks. Maybe an unpopular opinion but here we go. There is a lot of conflicting advice online and most of it is from 2019.

Quick context: I am relatively new to this and trying to find my footing.