First post and you fail to understand a simile with a pinch of irony ... anyway, Welcome to CS.
Soon you'll see that such generic questions as posted by the thread starter (short: TS) will not serve anything. It's to broad and leaves too much possible answers which in return will not help.
Most important is the definition of "affordable". Some people have trouble to fork out $12,000 while others can easily spend $1,500 - you get the idea?
After the budget is set let's add some more to cover the necessary side-items like batteries, memory cards, cleaning kit, dry box / dry cabinet. Then TS can have a look at the Buy&Sell section here to get a first idea what cameras could fit the budget. After shortlisting a few and reading reviews about the brands and models he could go to some shops to get in touch with the cams. Each brand has its own Look & Feel. And: each of the brands has cameras capable of taking decent pictures. No point asking "C or N, which is better?"
If there are still questions open TS can post them here - but after some reading and learning these questions might be much more specific and will get him specific answers.