Will my chances of housing loan be affected if I cancel my credit cards after redeeming the sign up perks?

Cancelling new credit card doesn't , but keep the oldest / longest credits card helps better score If you always pay up in time.

See : https://blog.moneysmart.sg/credit-cards/unknowi...

If the new credit card doesn’t cost you any annual fee, you should not cancel as the cancellation can minus your Credit Score with Credit Bureau Singapore