Cardiff is a great City in its own right with its own identity.
Why keep comparing to others?
The cities that you mention aren’t exactly hotbeds of culture known worldwide.
Bristol is a wannabe Shoreditch with Massive Attack/Banksy and a heritage of Slavery.
Leeds and Sheffield may be good nights out but they are hardly Florence or Chicago.