We bought a $70 foam one from clark rubber. I and my 3 siblings all had foam matresses until we were well into our teens, and no issues - but there's no family history of back troubles, etc, and 3 of us moved to spring matresses around 18 years old.

We have however bought a bed with a very firm, wooden slat base to make sure he has reasonable support.