I'm an audio guy, not a visuals type, but the same questions apply to audio gear as well.
Your post is incredibly vague. What does "affordable" mean? It may mean under $1k to you but between $10k and $15k to someone else. My low/no/mini/micro budget production sound kit, which I recommend to those asking, will run about $1,500. It's all "prosumer"gear. A "beginner" professional production sound kit starts at about $10k, more than six (6) times the cost of a prosumer kit.
So try asking your question again. "I want a camera in the $________ range that has _____, ________ and _________. I plan on shooting __________. I have (no/a little/some/lots) of experience." You'll probably get responses that will have more applicability to your personal situation.