backport: merge bitcoin#23280 (coalesce chainstate loading sequence between {,non-}unittest codepaths)

backport: merge bitcoin#23280 (coalesce chainstate loading sequence between {,non-}unittest codepaths) #9479