ClickHouse code style recommends unsigned in every case when you don't need the sign: https://clickhouse.com/docs/development/style

No. It says the reverse: "11. unsigned. Use unsigned if necessary."

Unsigned is necessary only if you're working with bit fields, bit masks or require explicit modulo n-bit arithmetic.

For all other cases, use signed