Yes, sins have consequences. Some that we notice, others that we don’t notice. However that hadith you mentioned is in fact a reality. The reason is to have us fear sins, so we may return to Allah.
A man told imam Ali i missed praying at night, imam Ali told him it’s because of something you must have done during the day.
Sometimes it’s dua not being answered. Sometimes it is getting hurt.