Noble profession is already questionable because "madam"(should have its name changed, because the male character case should be called pimp, but it doesn't)profession, assuming you do the right steps, generates much, much more both in short and the long run, by far. Heck, its one of those unlocked at the start, I might point it out - under normal conditions takes a while to truly show off, but considering most high end runs involve recruiting the brothel lady and ranking her up in the arena, turning a handful of money into thousands, then into tens of thousands and then...you get the idea. Turns out training beautiful arena fighters as opposed to accumulating money via interest brings money much quicker both in the short and long run. And more characters to train in the arena, which means more money and combat ready characters.
Not to mention some of simpler ones like merchant, which solves loot problems, like a lot of loot related things if you engage in combat a lot, allowing to complete tasks that require items consistently, but also helps with getting very nice items like stamina potions which are too good to not have for yourself.
As for "profession that boosts main character stats to be viable in late-game" job, I would correct it is called God, yes the one that is rewarded for the hero profession run, that makes starters at their max level, allowing you to max their levels, if not at very least close to, in a single day of ranked arena battles - so far, it is the profession that makes your hero you know, not be weak late-game, and is pretty much also the recommended way to climb the challenges if you don't know what to do, purely because of how good it is.
Oh and manipulation+ option for some reason still gives the main character only 2 max stat uses...I'm not saying how bad ascended is, it is good for same reasons knowing trait is, but compared to knowing trait itself, which is a very flexible back-up option no matter the job, it lacks that flexibility.