The oil requirements are specified in your owner's manual. Do you have an owner's manual for the bike? The oil recommended by Honda is the same for either NC700X transmission. You are correct that the DCT has a second oil filter not present on the manual transmission model.
We do not make oil brand recommendations on the forum, as it instantly turns into the dreadful "oil thread." You would need to check the Rotella T6 bottle or spec sheet to see if it meets Honda's recommendations.