I agree with the above though the phenomena is generally said to have hit less bad in rural Finland than elsewhere. It seems like rural areas where it is distictly untrendy to live have a sort of built in partial protection against both coronavirus and architecturevirus.
Myself I have a Batchelor's degree in structural engineering which means that I have also studied enough architecture to be able to plan a not too advanced house without architect when needed. To me it seems like architects are scarcely able to think outside the cardboard box where they keep their old schoolbooks.When they are brave enough think outside the box tend to do it in ways that is more about turning artistic dreams usually directly inspired by another architect into reality than creating a functional building.
There are a few good architects though but they have become that good only because of their own willingness to learn practical thinking and their own character which is strong enough to swim against the current.
Engineers on the other hand tend to think that every customer is alike and every household alike so one size of one solution fits all. Most also have problems to undertand the load bearing structure of elderly buildings and who the standard solutions may have to be changed a bit to fit between load bearing walls or under joists.
Many of the most sucsessful modernisations or new builds that I have seen have locally have been planned in good cooperation between a practical minded and aesthetically aware customer who has ensured that things came out functional for the needs of his/her particular household while looking good to his/her taste, and a structural engineer who knew the technical limitations and was willing to discuss back and forth and suggest ideas that combined the essentials of the customer's wishes with uncomplicated technical solution while living up to building code.
And....first and foremost.
Never ever trust a builder.
Funny you should mention about "architects dreams" I saw an episode of George Clarkes "ugly house to lovely home" and 2 architects had a good design of adding 3 extentions to a home, each slightly smaller than the previous - "russian doll" they called it - and the design LOOKED great, problem was the actual BUILDING of it - which turned out to be a serious nightmare even for a company used to using the shutter system for pouring thin concrete walls - which in turn ended up turnign a 7 month project into..... 3 YEARS and a ridiculous overspend - which made me think the same thing; that the architects were spending other peoples money for an "artistic vision" of thier own.
"professionally ugly" - lol or "pro-fugly" which works on several levels
I think what the OP needs is called a "Sarah Beeny" who by chance has a show on at the moment about exactly this - swapping the interior design of a house to made it more logical and useful for the current owners - some of the shows have been really good, throwing out ideas I'd not have thought of although some of the shows had clients with an unfeasably small budget.
Research research research - and then more reasearch, before you even call a person to get a quote - think of all the ways the space might be used, and at different times of year, like Xmas with lots of family around etc, and make notes of all the ideas and thoughts, the "MUST HAVES" and the "would like's", don't start second guessing yourself at the beginning just throw them ALL down, then create a "mood board / folder" of all the pictures of things and ideas you like (great place is PINTEREST for pretty much every sort of interior you can think of), inc even mundane things like fittings, taps, what type of overhead lights - drop style or flush LED's or wall sconces, switch sockets white or metallic or even funkier, colour examples for walls and fabrics, what sort of decorations, where are you going to put pictures and shelving etc - all of it, because any "interior architect" worth a damn will want to know all of that information before they even pick up a pencil to start designing.
Also - don't get hung up on "design conventions" - yes you CAN have "modern urban" next to "country cottage" in the same building if it's done properly and sympathetically.
Go nuts - all ideas when it comes to design however mad are not inherently "bad" - and bit by bit you'll start to see a clearer picture of your personal tastes, and what boundaries you might consider expanding like colour / textures / fabrics and materials such as polished concrete, to name a current trend, which has lots of advantages BTW and can be visually stunning and not at all "1950's high rise".
Once you've got all that then you can start whittling stuff down regarding costs, swap this for that, stretch a bit here for that "must have" and remove a "would like" to balance the budget etc etc.
But most of all you need to KNOW WHAT YOU WANT, because 30+years of watching pretty much every program associated with building and interior design (I've been watching "This Old House" ever since the Bob Villa days and an entire shelf of books on the subject) in the UK and USA (and Australia and NZ) changing your mind when the work is being done can get REAL expensive.
HTH!