I was expecting a post about stat weights. So anything besides that is totally fine and not redundant. With that said, RDM is totally fine right now. The issue it has is it generally competes with two other jobs for one slot. Where melee (generally) competes for two slots, and the utility + damage of bard and machinist make them welcome in almost any party. For damage, it isn't so far behind that it's not worth taking. Any good red mage player is going to do more damage than an average player on any other job (with comparable gear) still. And red mage offers great utility with the near instant battle rez as well as the physical damage buff it provides with embolden.

So I wouldn't worry about changing from red mage if you like it. It's mostly just that there are SO MANY people playing dps jobs that that's what fills up first in party finder. And as a caster you are generally fighting for one spot in that party. So you have even smaller odds of getting in. Outside of that, if people are directly excluding you from a party finder group JUST because you are on red mage, they are doing something wrong.

Also, if you are looking to play a melee that is desired in groups it would go NIN > DRG >> MNK >> SAM. BUT, in regular party finder groups and nearly every group in general, just having good players is all that matters. You can run about any composition and clear all content that isn't super savage raiding.