Jira self-hosted is actually often a lot faster than Jira Cloud, if you have decent gear to run it on. You run the database too, so it's a matter of how much cash you want to throw at it. Jira and Postgres on decent storage can be pretty quick, though of course it's still 100x slower than any normal 1990s desktop app.