Contacts app

Tap on the words “All iPhone”. You should be able to see all your contacts.

Why did you turn off iCloud syncing for contacts? You should always have the contacts synced to your account. If you don’t, and you loss your phone or it’s damaged beyond use, you will lose your contacts.

From the Lists view, tap on "All Contacts". That should take you back to the Contacts screen.

For future reference, whenever something has an arrow at the far right (as, for example, All Contacts does), that means that if you tap on that, it will take you to another screen or set of options. In this case, I agree that the arrow is quite faint.

That may have something to do with turning off iCloud syncing, keep the contacts on your phone, then, at some point turning it back on again. I would suggest you delete the all the contacts from one location or the other and then re-sync but, that’s entirely up to you.

Personally, I have my contacts synced to both my Google account and my iCloud account. Any duplicates are linked automatically.