Ok, so start with
$$\hat\beta = (X^TX)^{-1}X^TY$$
and write this as $\hat\beta=AY$.
We now have
$$\mathrm{var}[\hat\beta] = A^T\mathrm{var}[Y]A$$
as a property of linear transformations, so
$$\mathrm{var}[\hat\beta] = (X^TX)^{-1} X^T\mathrm{var}[Y]X (X^TX)^{-1}$$
You have this re-grouped as
$$\mathrm{var}[\hat\beta] = (X^TX)^{-1} \left(X^T\mathrm{var}[Y]X\right) (X^TX)^{-1}$$
So, what does the matrix $\mathrm{var}[Y]$ look like? If different $Y$s are independent, the matrix is diagonal, with the variances of individual $Y$s as the diagonal elements. $\Omega$ doesn't have any very illuminating form; it's a sum of matrices of the form $x_ix_i^T$ weighted by the individual variances of the observations.
If the variances are all the same, $\mathrm{var}[Y]$ is just $\sigma^2$ times an $n\times n$ identity matrix and the formula simplifies to the familiar homoscedastic formula. $\Omega$ is then just $\sigma^2 X^TX$.
Asymptotically, it's convenient to put in some $n$s and consider
$$n\mathrm{var}[\hat\beta]= \left(\frac{1}{n} X^TX)\right)^{-1} \left(\frac{1}{n}X^T\mathrm{var}[Y]X\right)\left(\frac{1}{n} X^TX\right)^{-1}$$
This has the advantage that all the bits are means and actually converge to non-zero constants (under some assumptions) with $ n\mathrm{var}[\hat\beta]$ being the limiting variance of $\sqrt{n}(\hat\beta-\beta_0)$. By contrast $\mathrm{var}[\hat\beta]$ just converges to zero; $\mathrm{\hat\beta}$ gets less and less variable as $n$ increases.
Finally, you might also be interested in the heteroscedasticity-consistent estimator that's a plug-in version of this. The estimator has the same $X^TX$ matrix
$$\widehat{\mathrm{var}}[\hat\beta] = (X^TX)^{-1} \left(X^T\widehat{\mathrm{var}}[Y]X\right) (X^TX)^{-1}$$
Here, $\widehat{\mathrm{var}}[Y]$ is again a diagonal matrix, with the diagonal elements being $(y_i-x_i\hat\beta)^2$. Again, if you want to work asymptotically it's convenient to put in $1/n$s everywhere so that the components of the estimator are each means that have straightforward limits.