That is definitely bizarre. I can't tell from the perspective of the pictures you attached exactly how high your ceiling is, but I had an electrician in my house recently who replaced a ceiling fan that was 18' off the floor. They have tall ladders. Any higher than that you would probably have to have scaffolding built. If you happen to also be planning to paint, the painters will need scaffolding and you could ask them to let the electrician piggyback on their installation. I don't know if they would even agree to that, but it would be worth asking.

The ceiling fans should be hanging lower in order to work better, and you can get a light added to the existing ones, or if they date from when the house was built they should just be replaced. I can't tell how big the room is and if you even need two fans. Ideally you would have recessed lighting in your ceiling, but that is usually done when the house is built. It's surprisingly difficult and expensive to do it after the fact.

In any case, your issues can be addressed by an electrician - not a handyman, a licensed electrician. You could also try going to a lighting store and see if they have someone competent to advise you. There is a place like this near me, but I don't know where you are.

Anyone willing to share style ideas for the chandelier?
I keep looking on Pinterest but I feel so stuck 🤔

What style do you prefer for your decor? We can help with a chandelier easily enough. But in the meantime - as others have already hinted at - you may have a bigger job on your hands. All that electrical was no doubt done after the house was built and likely has code issues. I agree with previous comments, though even with recessed lighting, it’s so far away, I’m not sure it’ll help much. You still need lighting closer to the floor. I’m not even sure the fans are necessary. If you have lighting and fan done properly, you’ll probably need drywall and texture repair. Definitely get an electrician out for advice. An experienced one will tell you the status of your current circuit load, know what’s involved in improving it, and most likely be able to advise with function and design they are experiencing in the field. They can tell you what will or will not work.

I think the lighting was done when the house was built.
There was only one previous owner, and he had the house built in 1989.

However…we have lots of ‘questionable’ things going on that he did and we have to fix.
This is one of them🤣

The Dining chandelier is too small and at the wrong height. The fans are too small and in-effectual at the existing height. You might be able to add 1-2 wall sconces to help light the stairs themselves.
Tall spaces in a home want/need light at different levels - e.g. uplighting might be used to bounce light off the ceiling to prevent that from being a dark void and to create some ambient light, while lower fixtures will provide task light, and aome accent lights can be used to light art / architecture to create interest & contrast in the space.
To get ideas on actual fixtures you need to offer style clues so commenters can offer constructive targetted solutions for you to consider.
Ideally you want to consult an experienced design professional to help you reach the best outcome.