I understand that many construction jobs are very long hours, for 5, 6, or even 7 days a week during the summer, then laid off in the winter.
With your physical challenges you ought not take a physically demanding job -- driving a dump truck, any other type of construction, or anything that you'd have to be on your feet for a long time. Even if you got the job and could stand the pain, your productivity would probably be less than others, and you'd have constant conflict with your supervisor or foreman.

I'm not sure even a Rent-A-Center job would be a good idea for you.
20 years ago, when I changed careers at age 40, one of my classmates at the time had been a roofer before he developed epilepsy.

Epileptic convulsions while on a rooftop are not a good thing, so he had to change his line of work. He decided to go into computer programming; while not brilliant at it, his code worked and he was ok. He's probably retired by now.
There should be a place for some testing and job counseling -- whether through your state's unemployment or workers' comp bureau. Contact them and (persistently) ask for testing and guidance, stressing that you really do want and need to find a line of work you can do. You will probably need more education to get into some type of white-collar job, but if Greg could do it, so can you if you really want to. I don't want to offend, but that education should also include spelling and grammar for you to transition to a desk job. Your state agencies should even help you finance some of it.
Your family is well-meaning, and knows that you really do need to get active and *do* something, although I suspect their viewpoints may be a bit limited. A good friend of ours made a good income as an author, but his mother kept asking himn when he was going to get a real job. He made more money writing that he could have made as an employee for someone else.
There's lots of ways to make an honest living. You just need to diligently find a good way for you.