Define "inexpensive" and "ideal".
A couple of years ago I got a Sony PXW-Z150. Large single 1" imaging chip, XLR audio inputs, 4K video capture, connects to my 7" external monitor from a previous (1080p) camcorder, top handle, manual zoom, manual focus, manual aperture, manual audio gain controls, dual SDXC card slots, 62mm lens diameter, built-in infrared emitter to capture monochrome video in zero visible light and lots more... Uses the same batteries from a few earlier camcorders, works great with my Steadycam vest/arm system, decent built-in mics... Used it a bunch for shorts and sporting events... Compared to what I want to get, it is "affordable"... and for shorts, is great.
If you want someone to tell you something in the $500 range, you won't get most of the above features, hence, not "ideal".