Interesting topic and timely for me.
Having recently redone our kitchen and painted and putting in new carpets in the next week or two, it came to our home office and what to do. Two previous tables (one a "computer" style desk and the other a simple Ikea construction) never really fit the room ideally, nor the décor (particularly not with new paint and new carpets coming).
We looked at HEAPS of options, but most were either functional but lacking in aesthetics or beautiful but not functional. Finally, we found someone who custom manufactures dining tables and other furniture and we have a 2700mmx900mm table being made at the moment that will fill most of one wall space (which itself is less than the room width because of a column-like structure in one corner). It will sit perfectly leaving room for an antique folding card table to "slot away" when not in use and give a great working space that is attractive and functional in its simplicity. It provides for both my wife and I (her use is only occassional) and to put a desktop printer, DAS device, phone, computer monitors, wacom, and so on.
My take away, if it's going to be something you use for a long time, it's worth looking at custom options and getting something that you consider is right for the space. In this case, at around $3,000- delivered and installed (they put it together onsite, and it's far more study than an Ikea, with a proper frame), it's not cheap, and probably 2.5-3x the cost of getting a couple of Ikea desks (from their better quality options), but it will help to keep the room looking like it doesn't have random desks in it, but instead a piece of furniture that suits in terms of overall aesthetic whilst still being as functional as we needed. In the long term, that extra cost will be very little, spread over the likely lifetime of the table of several decades, and we'll enjoy it and the room much more.