Anita, during a renovation in our last house I had to move my writing table desk and a chair up to the master bedroom and work there during the day. There was a space against one wall and, honestly, it was really nice working there. The room was very pretty, nicely decorated, and enjoyable to be in. It had a very cozy and private feel, and the decorator I was using at that time also told me that historically the upper classes had writing tables and bookcases in their master bedroom and the ladies would sometimes spend all day in there. Don't know if she was right or not, but I know I could spend all day in there working on things. So I think the idea of putting the desk in a nicely done up guest room would be excellent. If the computer table in the breakfast/kitchen area is already piled with junk -- which happens A LOT in kitchens -- this could happen to the work desk too, and it might not be too much fun to work at. Do you think the homework etc., could be properly done with others watching TV and socializing in the family room? It doesn't seem likely but if so, then that sounds like a good idea too. I saw a model home where they had a desk in part of the living room and it looked great. I don't know how much of a neatnick you are, but if I had a desk in the public area, it would have to be kept neat, not a bunch of papers strewn around (as in my study, for example), so you might want to take that into consideration.

More light as well as more storage. Replace those table legs with a stack of drawers (look at Ikea's "Alex") that you can use as your desk legs - I have them, and their height is perfect to add a tabletop onto -- that's one of their intended uses. You can get all drawers, or drawers and a filing drawer like the one pictured. You might want to consider some type of wall-hung storage, but it depends on your style and the kind of things you want stored.....but I like them as they add to empty walls and make them look less empty. Things like this hanging magazine/file rack, or this one that is 4 hanging canvas bags that could hold anything from your phone charger to emergency flashlight or extension cord.

Post pics of your room and a to scale floor plan

You mentioned standing desk option. I recently purchased one of these: https://vivo-us.com/collections/desk-converters/products/desk-v000m Very portable, inexpensive, goes up and down and comes in several sizes. You can easily go from a desk area to dining room. I also looked at a rolling desk with storage that adjusts up and down like this: https://www.amazon.com/FEZIBO-Adjustable-Electric-Standing-Tabletop/dp/B091YLQ6ZG/ref=sr_1_37?crid=3FVECBRIMRGIZ&keywords=rolling+desk+with+drawers&qid=1660591394&sprefix=rolling+desk+with+drawers%2Caps%2C157&sr=8-37 When you have company, simply roll it to a different area of your condo. Lots of selections on Amazon.