If the NAT function is running on a box that I can walk over and kick, then it is absolutely under my control. :)
CGNAT is a different discussion entirely. Neither the presence nor absence of upstream CGNAT changes my thoughts on locally-administrated NAT for my own LAN in IPv6 land.
When people complain about NAT they're mostly worried about NAT they don't control. CGNAT, or trying to deliver something that works on normal consumer computers without an expert user.